Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: fetching long variable in PL/SQL

RE: fetching long variable in PL/SQL

From: <A.Bahar_at_billing-components.com>
Date: Mon, 26 Jan 2004 00:34:25 -0800
Message-ID: <F001.005DE1CB.20040126003425@fatcity.com>


Okey but how can I convert it

-----Original Message-----
Sent: Sunday, January 25, 2004 4:44 PM
To: Multiple recipients of list ORACLE-L

convert to a lob and use a substr. That might fix the problem. ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, January 25, 2004 10:24 AM

>
>
>
>
> Hi all ,
> I have a problem about fetching long variable in PL/SQL.
> I encountered with problem in following PL/SQL block.
> When I try to fetch long variable , I receive " PL/SQL: numeric or
value error ORA-06512".
> As I searched in metalink, it is releated to size of long variable.
Probably it is greather than
> 32KB.
> I could not find a solution.
> Do you have any info or and advice that how I can fetch long variables
greather than 32KB.
> May it can be divided into more than one variable but how.
> Thanks
> Arslan.
>
>
> DECLARE
>
> USER_TRIGGERS_COUNT NUMBER := 0;
> USER_TRIGGERS_COUNTER NUMBER := 0;
>
> CURSOR USER_TRIGGERS_CUR IS
> SELECT TRIGGER_NAME ,DESCRIPTION , trigger_BODY FROM USER_TRIGGERS
> where trigger_name = 'TRG_APPL_CONTRACTS_BIUD_R' ;
> USER_TRIGGERS_R USER_TRIGGERS_CUR%ROWTYPE;
>
> BEGIN
> select COUNT(*) INTO USER_TRIGGERS_COUNT from USER_OBJECTS WHERE
OBJECT_TYPE = 'TRIGGER';
> OPEN USER_TRIGGERS_CUR;
> LOOP
> FETCH USER_TRIGGERS_CUR INTO l_TRIGGER_NAME ,l_DESCRIPTION ,l_BODY ;
> EXIT WHEN(USER_TRIGGERS_CUR%NOTFOUND );
> NULL;
> END LOOP;
> CLOSE USER_TRIGGERS_CUR;
> END;
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <A.Bahar_at_billing-components.com
> INET: A.Bahar_at_billing-components.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: ryan.gaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <A.Bahar_at_billing-components.com
  INET: A.Bahar_at_billing-components.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jan 26 2004 - 02:34:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US