Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Variable
Hi,
I've got following error
old 7: strTblName := '&1';
new 7: strTblName := 'TB_B4000';
ERROR:
ORA-01756: quoted string not properly terminated
And my SQL is
declare
strTblName char;
s number;
b date;
BEGIN
b:=sysdate;
strTblName := '&1';
END;
Pls guide me what mistakes in my SQL.
Thanks.
Cheers, Received on Thu Apr 26 2007 - 21:59:53 CDT