Oracle Database Discussions

Hi,

I am executing a sql script file that has a series of calls to some custom pl/sql api
(called to insert roughly 1 lakh records). The file size is 10MB.

I am executing it as:

SQL>@upgrade.sql;

However it just prints out a number like

SQL>@upgrade.sql;
36777

and does not return to the sql prompt. (There is no dbms_output.put_line statement that prints such number inside the script)

Is there a limit to the sql script that we can execute, and any way to increase this limit if there is?

If I pick out a part of the script with begin and end block, and execute it (to insert say around 10 records) from sqldeveloper it works fine. Therefore there does not seem to be any syntax issue.

If this question has been already answered, kindly let me know the link as I could not find a similar issue in the search.

Thanks,
Rommel.