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
ramora
Messages: 16
Registered: November 2006
Location: hyderabad
Junior Member
Hi,

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
RAM.

  • Attachment: db.sql
    (Size: 0.41KB, Downloaded 172 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: 64103
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.

Regards
Michel

[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 Dec 04 10:47:36 CST 2016

Total time taken to generate the page: 0.10258 seconds