Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Variable

SQL Variable

From: beerora <beersa.beersa_at_gmail.com>
Date: 26 Apr 2007 19:59:53 -0700
Message-ID: <1177642793.848582.253250@t38g2000prd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US