Home » SQL & PL/SQL » SQL & PL/SQL » execute immediate with nvarchar data type (9i)
execute immediate with nvarchar data type [message #325239] Thu, 05 June 2008 06:17 Go to next message
Messages: 16
Registered: November 2006
Location: hyderabad
Junior Member

while i am given a string to execute immediate(dynamic sql) that string data type should not varchar(nvarchar or clob) it gives the compliation error.
But as per my requirement i need to use nvarchar/nclob data type only because i am working with french data. please find the attached script. please help me thanks in advance.

Thanks & Regards

  • Attachment: db.sql
    (Size: 0.41KB, Downloaded 170 times)
Re: execute immediate with nvarchar data type [message #325242 is a reply to message #325239] Thu, 05 June 2008 06:21 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't use a string of N... datatype in execute immediate but data values can be, just use bind variables.

And please when your code is only 10 lines post it directly don't use an attach file.


[Updated on: Thu, 05 June 2008 06:22]

Report message to a moderator

Previous Topic: How to get Error Line Number in PL/SQL in Exception Block
Next Topic: get error through FORMAT_ERROR_BACKTRACE
Goto Forum:

Current Time: Sun Oct 23 13:29:45 CDT 2016

Total time taken to generate the page: 0.12827 seconds