Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00172: string literal too long
PLS-00172: string literal too long [message #222074] Thu, 01 March 2007 11:32 Go to next message
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.
Re: PLS-00172: string literal too long [message #222101 is a reply to message #222074] Thu, 01 March 2007 16:16 Go to previous message
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

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


Current Time: Thu Dec 08 12:39:40 CST 2016

Total time taken to generate the page: 0.14695 seconds