I am using dbms_metadata PL/SQL supplied package to extract all the
objects from the oracle database into files. So far I have generated the source code for Functions & Triggers. Functions seems to be absolutely fine. But there seems to be some kind of a problem with Triggers. Some of the triggers were'nt extracted completely and some were. Not quite sure why this is happening. I am using exactly the same code for functions & triggers.
Is anybody aware as to what could be the problem. Or if there is a bug
with the dbms_metadata package.
I appreciate your prompt response. I dont think that should be a problem since , there are larger triggers which are getting extracted completely. Anyways for your reference here is the code (which is derived from the oracle documentation):
PROCEDURE write_lob(doc IN CLOB, fileHandle UTL_FILE.FILE_TYPE) IS
offset number := 1;
cloblen := dbms_lob.getlength(doc);
WHILE cloblen > 0
IF cloblen > 32760 THEN
amount := 32760;
amount := cloblen;