Home » Open Source » Programming Interfaces » Execute Firebird procedure from Oracle (Oracle Database 10g Release 10.2.0.5.0 + Firebird )
Execute Firebird procedure from Oracle [message #518239] Tue, 02 August 2011 07:17
Buchas
Messages: 101
Registered: March 2006
Senior Member
Hello,

I have the following procedure in Firebird:

SET TERM ^ ;
ALTER PROCEDURE PINGAS
RETURNS (
    RESULT Smallint )
AS
begin
        Result = 1;
        SUSPEND;
end^
SET TERM ; ^


GRANT EXECUTE
 ON PROCEDURE PINGAS TO  SYSDBA;



I have created a DB_LINKas from Oracle to Firebird connected to user SYSDBA, and I am able to access tables from Firebird.

How can I execute the procedure? (It should return 1)

Those tries do not work:
declare 
  i int;
begin
i:=   SYSDBA.PINGAS@STEKAS ;
--Error: identifier 'SYSDBA.PINGAS@DB_LINKas'  must be declared.
end;


declare 
begin
SYSDBA.PINGAS@STEKAS ;  
--Error: identifier 'SYSDBA.PINGAS@DB_LINKas'  must be declared.
end;


SELECT p.RESULT FROM PINGAS@DB_LINKas p
--Error: Table or view does not exist
Previous Topic: Python App =>Causes of: ORA-22065 OCI-22065:
Next Topic: Excel/Oracle ODBC with Nested Tables
Goto Forum:
  


Current Time: Thu Mar 28 11:23:03 CDT 2024