Buchas
14 years ago
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:= ***@STEKAS ;
--Error: identifier '***@DB_LINKas' must be declared.
end;
declare
begin
***@STEKAS ;
--Error: identifier '***@DB_LINKas' must be declared.
end;
SELECT p.RESULT FROM ***@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.
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:= ***@STEKAS ;
--Error: identifier '***@DB_LINKas' must be declared.
end;
declare
begin
***@STEKAS ;
--Error: identifier '***@DB_LINKas' must be declared.
end;
SELECT p.RESULT FROM ***@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.