Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic sql and ' or "
Dynamic sql and ' or " [message #37470] Mon, 11 February 2002 01:32 Go to next message
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.
Re: Dynamic sql and ' or " [message #37471 is a reply to message #37470] Mon, 11 February 2002 01:40 Go to previous messageGo to next message
Anthony
Messages: 48
Registered: September 2000
Member
Actually thats Oracle 8.0.3 not 7.3 as stated earlier
Re: Dynamic sql and ' or " [message #37496 is a reply to message #37470] Tue, 12 February 2002 02:01 Go to previous message
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
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:
  


Current Time: Thu Mar 28 17:09:29 CDT 2024