Yeah, I know that it works from FB.
But I want an application which is running on Oracle to access the logic of
some other application that is based on Firebird procedures. I was wondering
if it can be made using DB link from Oracle to FireBird.
--
View this message in context:
http://firebird.11
11.08.2011 16:04, Buchas wrote:
> It does not work. Oracle says "Table or view does not exist."
Use DBMS_HS_PASSTHROUGH package.
--
SY, SD.
--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user a
that is a different issue, if you run the "select " against the firebird
database directly it will work
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3735943.html
Sent from the firebird-odbc-devel mailing list archive a
It does not work. Oracle says "Table or view does not exist."
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3735927.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
---
such a procedure needs to be called as if it were a table
select * from
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3733098.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
---
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 f
