OraFAQ Forum: SQL & PL/SQL » Dynamic sql and ' or "

Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic sql and ' or "

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic sql and ' or " [message #37470]

Mon, 11 February 2002 01:32

Anthony
Messages: 48
Registered: September 2000

Member

Hello all,

I want to execute a dynamic SQL statement in Ora 7.3. The only problem is that I would like to include a value that comes in quotation marks. I get the usual errors when I run it when I tried using ''xyz'' and with "xyz" do I have to bind it or is there another way.

Report message to a moderator

Re: Dynamic sql and ' or " [message #37471 is a reply to message #37470]

Mon, 11 February 2002 01:40

Anthony
Messages: 48
Registered: September 2000

Member

Actually thats Oracle 8.0.3 not 7.3 as stated earlier

Report message to a moderator

Re: Dynamic sql and ' or " [message #37496 is a reply to message #37470]

Tue, 12 February 2002 02:01

Anthony
Messages: 48
Registered: September 2000

Member

Thanks I worked this one out myself, I had to use the bind variable from the DBMS_SQL package.

Thanks once again

Report message to a moderator

Previous Topic:	Re: steps after sucessfully created the cursor
Next Topic:	after coding the sucessful cursor what are the steps to get the cursor output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 24 22:24:29 CDT 2026