[cx-oracle-users] callproc dbms_metadata.add_file

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div>

<div>&nbsp;</div>

<div>I&#39;m writing a little script which exports some data from my database and I want to use dbms_datapump.</div>

<div>&nbsp;</div>

<div>It almost works, I am stuck with the logfile though. To create one, you have to use the function dbms_datapump.add_file:</div>

<div>&nbsp;</div>

<div>
<pre class="oac_no_warn">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&#36;_FILE_TYPE_DUMP_FILE),
   reusefile  IN NUMBER DEFAULT NULL;</pre>

<div>&nbsp;</div>

<div>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 ...)</div>

<div>&nbsp;</div>

<div>
<div>cur.callproc(&#39;dbms_datapump.add_file&#39;,[handle,&#39;test.log&#39;,&#39;EXP_IMP&#39;,102400,&#39;KU&#36;_FILE_TYPE_LOG_FILE&#39;])<br/>
cx_Oracle.DatabaseError: ORA-06502: PL/SQL: numeric or value error: character to number conversion error</div>

<div>&nbsp;</div>

<div>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).</div>

<div>&nbsp;</div>

<div>so, how can I get this to work? the parameter filesize is optional but how can I write that?</div>

<div>&nbsp;</div>

<div>br,</div>

<div>&nbsp;</div>

<div>Werner</div>

<div>&nbsp;</div>
</div>
</div></div></body></html>