Home » Developer & Programmer » Precompilers, OCI & OCCI » Problems with extdemo2 (extensible indexing) (newbie) (Enterprise Edition, 11.1g, WinXP)
icon9.gif  Problems with extdemo2 (extensible indexing) (newbie) [message #317277] Wed, 30 April 2008 06:03 Go to next message
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 #317285 is a reply to message #317277] Wed, 30 April 2008 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: Problems with extdemo2 (extensible indexing) (newbie) [message #317293 is a reply to message #317285] Wed, 30 April 2008 06:55 Go to previous message
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



Previous Topic: revert back data in UNIX
Next Topic: Compiler settings for extensible indexing
Goto Forum:
  


Current Time: Fri Mar 29 04:48:59 CDT 2024