Home » SQL & PL/SQL » SQL & PL/SQL » ole2 not declared
ole2 not declared [message #36970] Tue, 08 January 2002 06:55 Go to next message
fionan
Messages: 5
Registered: January 2002
Junior Member
hi
i am creating a stored procedure to be run on oracle application server.i am writing a pl/sql procedure that writes to an excel file.i think i should be using ole_app_hndl := OLE2.CREATE_OBJ
( 'Excel.Application.5' );
but when i use this it gives me the error
(1): PLS-00201: identifier 'OLE2.OBJ_TYPE' must be declared does any one know am i missing a library or does anyone have code for a pl/sql procedure that would create and write to an excel spreadsheet

any ideas appreciated
fk
Re: ole2 not declared [message #37019 is a reply to message #36970] Thu, 10 January 2002 05:50 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

OLE2 is a built-in-package not a procedure/function/package(database). u can not use it in server-side pl/sql.u can use it in developer-2000.

cheers
pratap
Previous Topic: Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable
Next Topic: create file problems with oracle
Goto Forum:
  


Current Time: Mon Aug 03 04:43:34 CDT 2020