 Problems with extdemo2 (extensible indexing) (newbie) [message #317277] |
Wed, 30 April 2008 06:03  |
phaeuschen
Messages: 6
Registered: April 2008
|
Junior Member |
|
|
Hi,
I unsuccessfully tried to get the extdemo2 working.
I compiled extdemo2.c and extdemo2.h successfully to extdemo2.dll and copied it to "C:\Oracle\product\11.1.0\db_1\MyLibs\".
I executed "CREATE OR REPLACE library extdemo2.extdemo2l AS '%ORACLE_HOME%/MyLibs/extdemo2.dll'" in Oracle SQL Developer to create the library.
After that, I executed all needed sqls from extdemo2.sql and the
table with it indexed column were successfully created.
But when I execute "select * from t1 where eq(f2, 'ravi') = 1;" I get following error message:
Error starting at line 1 in command:
select * from t1 where eq(f2, 'ravi') = 1
Error report:
SQL Error: ORA-29902: Fehler bei der Ausführung von Routine ODCIIndexStart() (Error in executing ODCIIndexStart() routine)
ORA-28578: Protokollfehler während Callback einer externen Prozedur (protocol error during callback from an external procedure)
ORA-06512: in "EXTDEMO2.SBTREE_IM", Zeile(row) 110
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and take appropriate action.
What went wrong?
How can I test if the library is created successfully? Does I need special compiler options in VS2005?
Can I debug the dll from VS2005 during a call by the database?
|
|
|
|
|
|
| Re: Problems with extdemo2 (extensible indexing) (newbie) [message #317293 is a reply to message #317285] |
Wed, 30 April 2008 06:55  |
phaeuschen
Messages: 6
Registered: April 2008
|
Junior Member |
|
|
Hi Micheal,
ok, I will contact Oralce Customer Support.
Thanks
| Michel Cadot wrote on Wed, 30 April 2008 13:30 | ORA-28578: protocol error during callback from an external procedure
*Cause: An internal protocol error occurred while trying to execute a
callback to the Oracle server from the user's 3GL routine.
*Action: Contact Oracle customer support.
Regards
Michel
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
