OraFAQ Forum: SQL & PL/SQL » PLS-00172: string literal too long

Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00172: string literal too long

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

PLS-00172: string literal too long [message #222074]

Thu, 01 March 2007 11:32

mayank.maria
Messages: 1
Registered: March 2007

Junior Member

Hi,

I am getting PLS-00172: string literal too long error when i try to run the .sql file from sqlprompt.

start D:/insertData.sql file.

But when i insert the data individually (row by row) on sqlplus prompt, it doesnt give any error.

Thanks in advance. Any help in this regard is appreciated.

Attachment: insertData.sql
(Size: 688.78KB, Downloaded 1118 times)

Report message to a moderator

Re: PLS-00172: string literal too long [message #222101 is a reply to message #222074]

Thu, 01 March 2007 16:16

andrew again
Messages: 2577
Registered: March 2000

Senior Member

you can try assigning the XML to a PL/sql variable (up to 32k) and insert that way. It's probably easier to use sql*loader.

http://www.orafaq.com/faqloadr.htm#LOBS

Report message to a moderator

Previous Topic:	tbl with two foreign keys
Next Topic:	to pass file name as a variable and parse it

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 24 20:53:23 CDT 2025