Hi!

Thanks!

I dont know. This question was from the Russian VFP forum, I just forwarded it here...

>>Hi!
>>
>>>In Oracle, I think you may try to adjust the value of SHARED_SPOOL_SIZE and
>>DB_BLOCK_BUFFERS.
>>
>>How I can do this? Can you post a sample of PL/SQL command for this, or tell where to go to configure these values?
>
>Hi Vlad,
>
>It's in the database initialization parameter file - init???.ora.
>The database is required to restart after the changes have been made.
>
>But I've read the Oracle doc., the PL/SQL block size limitation is around 32K.
>And Oracle's suggestion is breaking it into sub-blocks, like this:
>BEGIN
> BEGIN
> INSERT INTO vfp_test1 VALUES ('testing');
> END;
> BEGIN
> INSERT INTO vfp_test2 VALUES ('testing');
> END;
> ......
> ...
> commit;
>END;
>
>Just curious, why it can be done by SQL pass-thought.