Re: callproc dbms_metadata.add_file

What does the rest of your script look like?  Have you called
DBMS_DATAPUMP.OPEN() to generate the handle you're using in the proc you're
having trouble with?


On 24 September 2014 20:18, Werner Moser <[email protected]> wrote:

> Hi,
>
> I'm writing a little script which exports some data from my database and I
> want to use dbms_datapump.
>
> It almost works, I am stuck with the logfile though. To create one, you
> have to use the function dbms_datapump.add_file:
>
>
> DBMS_DATAPUMP.ADD_FILE (
>    handle     IN NUMBER,
>    filename   IN VARCHAR2,
>    directory  IN VARCHAR2,
>    filesize   IN VARCHAR2 DEFAULT NULL,
>    filetype   IN NUMBER DEFAULT DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE),
>    reusefile  IN NUMBER DEFAULT NULL;
>
>
> when I call it with the first five parameters, I always get an ORA-6502 -
> for the size of the file (which is not needed for the logfile ...)
>
>
> cur.callproc('dbms_datapump.add_file',[handle,'test.log','EXP_IMP',102400,'KU$_FILE_TYPE_LOG_FILE'])
> cx_Oracle.DatabaseError: ORA-06502: PL/SQL: numeric or value error:
> character to number conversion error
>
> As far as I have found out only positional parameters can be used, i.e. a
> dict or key/value is not supported - if it was I could use only the needed
> parameters here (handle, filename, directory and filetype).
>
> so, how can I get this to work? the parameter filesize is optional but how
> can I write that?
>
> br,
>
> Werner
>
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users