Select trunc(:StDT) as rptStartDT from DUAL;
So I have a multiple step Query that I need to have a Date parameter on each step, same date just used several times.
If I use the bind variable I get errors “ORA-01036: illegal Variable Name/Number” and it would prompt me for each time I used it.
So I thought ok I would create a table with just the date parms then just join this table in with all steps. If I run the select without create it works great as soon as I use the Create I get the above error. And as soon as I start using PL/SQL with a Declare, Begin, End. then it really throws a monkey wrench because of all the Create Table statements and Drop Table Statements. Oh I am not a fan of Oracle, but it is what I have to use.
create table tmpParms as