Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01024: invalid datatype in OCI call

Nitin JoshiNov 9 2006 — edited Nov 9 2006

Dear all,
Why i'm getting this error?
1* select dbms_metadata.get_ddl('TABLE','T2','INVTEST') from dual

select dbms_metadata.get_ddl('TABLE','T2','INVTEST') from dual
*
ERROR at line 1:
ORA-01024: invalid datatype in OCI call

SQL>CONN INVENTORY/TESTRUN@ISSL
Connected.
SQL>/
select dbms_metadata.get_ddl('TABLE','T2','INVTEST') from dual
*
ERROR at line 1:
ORA-01024: invalid datatype in OCI call

1* select dbms_metadata.get_ddl('TABLE','GRN_MASTER','INVENTORY') from dual
SQL>/
select dbms_metadata.get_ddl('TABLE','GRN_MASTER','INVENTORY') from dual
*
ERROR at line 1:
ORA-01024: invalid datatype in OCI call

i've 9.2 with win2k server

Your views Pls..

Thanx in Advance!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2006

Added on Nov 9 2006

#general-database-discussions

1 comment

3,101 views