Hey, can anyone tell me what I need to do to make the following syntax legal
This statement will work. Batchnumber[x] is a string array that either has a 5 character text string, or a single space in each element
{IVC.IVC_BATCH_NO} in switch
(
{?Report Type} = "P"...
Hey, I have a date parameter and I want to have a default value that is always 1 year prior to the current date. However, from what I know, I can only set the default values for a parameter to be a constant value (i.e. I can set the default date to be July 17, 2001, but this value will never...
I had tried that, and it also fails. It gives an error of:
The following error has occurred:
ORA-06550: line 17, column 22:
PLS-00307: too many declarations of 'TO_CHAR' match this call
ORA-06550: line 17, column 1:
PL/SQL: Statement ignored
At the bottom of this code are tow dbms_output statements. The second one always fails with this error message
"The following error has occurred:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_OUTPUT", line 64
ORA-06512: at line 17"
Does anyone know why...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.