This content has been marked as final. Show 4 replies
What's the DDL for the CUSTOMER table look like?
How are you running this?
What version? (4 digits)
I can't think of anything else that would be needed to complete a test case/script a random person could use to duplicate the issue but if you are aware of anything, please include it.
Also, since I see you just started a new thread with this question, pick one spot to continue the discussion on
Hi a_non Table Structure SQL> desc tb_customerxml; Name Type Nullable Default Comments ----------- ------------- -------- ------- -------- CUSTOMER_ID NUMBER Y TYPE VARCHAR2(100) Y ACTIVE VARCHAR2(50) Y CREATED_DT VARCHAR2(30) Y CREATED_BY VARCHAR2(100) Y LAST_MOD_DT VARCHAR2(30) Y LAST_MOD_BY VARCHAR2(100) Y get_handoff_path(51); is a Procedure it returns the Directory Path. ex cheio/chennai/plo i execute procedure. pick the directory name open the file from directory reading the xml data. and placing the data into TABLE. execute the procedure like below, in anonymous block begin sp_insert_xml_emps; commit; end; version is ORACLE 11i.
version is ORACLE 11i.That's a marketing label. Your 4 digit version can be found via
select * from v$version
The documentation for [url http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions019.htm#SQLRF00610]BFILENAME states that the first parm is a directory object. Based off what you said, you are providing the server path instead. I doubt you have a directory object called "cheio/chennai/plo" defined in your system. You will need to create directory objects that reference the server paths. The BFILENAME documentation contains a reference to the [url http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5007.htm#i2061958]CREATE DIRECTORY documentation. You would just need to modify
to return the directory name instead of the path.