Re: command buffer space exhausted (extra info)

W.van.der.Deijl_at_inter.nl.net (W. van der Deijl) wrote:

I've found some extra info for the problem mentioned below. The problem occurs when executing the
\orawin\rdbms72\admin\prvtsql.plb script which is called from catproc.sql.

I've looked in prvtsql.plb and there are created three packages with "create or replace package <namer> WRAPPED".

I have no idea what WRAPPED means, but the 'body' of the package seems to contain only HEX-decimal codes. So I think it's like creating a package with compiled code, so end-users can not see the code.

I trief to cut the script in three parts (one part for each CREATE PACKAGE), but this won't help. The first one is succesfully executed. Then I shut down the database, restart the machine (to get a clean setup). I start the database an SQL*Plus 3.2 (Win95 version). When I execute the script to generate the seconde package, after about 2100 lines the messages "command buffer space exhausted" keep comming up, resulting in a packag compilation with errors.

The problem probably is the size of the CREATE PACKAGE-command, which is about 77Kb. But this is a script that came with the Oracle product, so I assume it must be able to execute.

Has anyone executed these scripts succesfully, so that the package dbms_sys_sql is created under Personal Oracle 7?

I'm getting really desperate. I've been trying to get Designer/2000 running on my PO7-95 machine for three days and think it's time it should work :-(

Any help would be greatly appriciated.

Thanks,
Wilfred.

>Hi,
 

>I am installing PO7-95, Developer/2000 (Win 3.1 version) and
>Designer/2000 (Win 3.1 version).
 

>I got PO7 and Dev/200 running, but am having problems installing
>Designer/2000. To use Designer I have to enable the procedural option
>in the database. It looks like I have to execute
>\orawin\rdbms72\admin\catproc.sql
 

>To do this I start SQL*Plus (v3.2, Win95) and connect as SYS. When I
>execute the script everything seems to work fine, until the packages
>are created (I think these ar dbms_sql, dbms_output etc.) When the
>script is creating these packages I get:
 

>command buffer space exhausted
>(about 20.000 times)
 

>I tried to enlarge allmost every option in Options->Set options (same
>settings as SET .....), but this did not help.
 

>I can remember something (from our office) that I should use SQL*DBA
>for these large scripts, but I do not have SQL*DBA with Personal
>Oracle, only SQL*Plus.
 

>Does anyone have any idea how to enlarge this command buffer space, or
>any other way to execute catproc.sql succesfully...
 

>Any help would be greatly appriciated.
 

>Bye,
>Wilfred
Received on Sun Nov 12 1995 - 00:00:00 CET