Re: Need PL/SQL suggestion

From: Svend Jensen <svejdk_at_ifsas.dk>
Date: Thu, 7 Oct 1999 15:46:44 +0200
Message-ID: <0T6L3.732$qe7.3094795333@news.euroconnect.net>

Try a static or dynamic SQL in Your PL/SQL block Like:
declare
...
...

cid_ number ;       -- cursor id for dynamic sql DDL's
cnt_ number ;       -- return value from dynamic SQL's
stmnt_ varchar2(2000) ;     -- variable for SQL statement

...
...
begin
...
...

stmnt := 'Your SQL statement - can be dynamic' ;

cid_ := dbms_sql.open_cursor ; -- open a cursor dbms_sql.parse(cid_, stmnt_, dbms_sql.native) ; -- parse statement cnt_ := dbms_sql.execute(cid_) ; -- exec statement ...
...
end ;

Regards /Svend_at_oraclecare.com
Greg Akins <insomniaNOinSPAM_at_a1usa.net.invalid> wrote in message news:04608828.422d05cc_at_usw-ex0108-059.remarq.com...
> Oracle 8.0.5
>
> I have already included the dbms_sql truncate... And I
> drop the indexes before performing the insert.
>
> I take it the nologging isn't available in 8.0.5? Any
> other way to replicate the speed of an SQL*Plus 'Copy'
>
> -greg
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Oct 07 1999 - 08:46:44 CDT