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
Messages: 1
Registered: March 2007
Junior Member

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.


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

Current Time: Thu Oct 27 14:09:33 CDT 2016

Total time taken to generate the page: 0.17840 seconds