I have to modify certain Oracle Packages. Basically I will be extracting functionality and moving it to C.
They provided me with some "Test" scripts that I shoud be able to run to test that my changes don't break the underlying logic of the package. But they are not working.
Also I noticed they have hardcoded some values in their original scripts and I am trying to use variables instead. I have never worked with Oracle so I am confused.
In Toad I have a Script along these lines:
select '23423DSSF34SD234' into myTestId from dual;
--Here my drop for my_test_table1 and my_test_table2
drop table my_test_table1;
drop table my_test_table2;
--Here create table my_test_table1 and my_test_table2
--Here I have a bunch of inserts
--Here are some selects statements
However when I run the script it fails when it reaches the "Drop" statements it doesn't like them. How can I perform drop statements in my script?
I have been reading around and it seems that in Oracle it is not a good idea to create temporary tables like this? What would be the best approach?