[Firebird-odbc-devel] Execute Firebird procedure from Oracle

[Buchas <val...@gm...>]

Hello,

I have the following procedure in Firebird:

Code: [Select all] [Show/ hide]

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


--
View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3712219.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.