Im calling a script that uses dynamic sql. Im passing in a value as well. I keep
getting
SP2-0552: Bind variable "2" not declared.
Here is a code snipped
declare
v_var1 Varchar2(30) := 'TEST';
v_var2 VARCHAR2(30) := '&1';
total number;
begin
execute immediate ' Select * ' ||
Your "using v_var1,v_var2" shouldn't be appended to the
string that represents the dynamic SQL to execute;
the "using..." is part of the syntac for execute immediate.
An Oracle error message being what they are, they don't
always highlight the correct cause of fault, but will
identify some other er
that was just a mock up of what I wrote. I dont have '||' in the real
version. Its jut a typo here. Anyone know what is going on?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 5:24 PM
> Your "using v_var1,v_var2" shouldn't