PL/SQL error 1

[mrn]

I have a pl/sql package dataload.dwhmain

when run I get the following

BEGIN DATALOAD.DWHMAIN; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ORCL.DATALOAD", line 738
ORA-06512: at line 1

How can I view this package to see which field/table is being updated.

Regards --
| Mike Nixon
| Unix Admin
|

http://www.instantflashshop.com

----------------------------

 

[mrn]

Sorry Oracle 8i --
| Mike Nixon
| Unix Admin
|

http://www.instantflashshop.com

----------------------------

 

[carp]

There are a couple of ways:

1. To see the source code:
SELECT line, text
FROM all_source
WHERE name = 'DATALOAD'
AND type = 'PACKAGE BODY'
ORDER BY 1;

2. To see what objects the package is dependent upon (which will include the tables/views):
SELECT referenced_type, referenced_owner, referenced_name
FROM all_dependencies
WHERE name = 'DATALOAD'
ORDER BY 1,2,3;

 

[sem]

I suppose that it was assignment, not update. You may look at the source code by issuing

select text from all_source
where owner = 'ORCL' and name = 'DATALOAD'
and type = 'PROCEDURE' and line = 738 Regards, Dima

 

[carp]

Mike - the error you're seeing is probably due to trying to stick a character string into a variable that's too small to hold it.

For instance, if you declare
my_variable VARCHAR2(5);

and then do something like

my_variable := 'Hello World.';

you will get this error, since you are trying to stick a 12-character string into a variable that can hold no more than 5 characters.

 

[mrn]

Thanks Carp,

I release what the error was, I just didn't know how to view the source, thanks for your quick reply and that's sem too. --
| Mike Nixon
| Unix Admin
|

http://www.instantflashshop.com

----------------------------