OraFAQ Forum: SQL & PL/SQL » execute immediate with nvarchar data type

Home » SQL & PL/SQL » SQL & PL/SQL » execute immediate with nvarchar data type (9i)

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

execute immediate with nvarchar data type [message #325239]

Thu, 05 June 2008 06:17

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 579 times)

Report message to a moderator

Re: execute immediate with nvarchar data type [message #325242 is a reply to message #325239]

Thu, 05 June 2008 06:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:15:41 CST 2024