| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 4953.1 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Thu Jan 23 1997 10:23 | 3 |
| 4953.2 | Here is the real stuff | chsr38.ch.oracle.com::ROHR | Oracle Rdb support Switzerland | Thu Jan 23 1997 11:09 | 210 |
| 4953.3 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Thu Jan 23 1997 23:16 | 18 |
| It still isn't clear to me, but I think you are creating the stored procedure
at runtime. I think you want the alias on the module name during the
create...
CREATE db2.MODULE MTESTST LANGUAGE SQL
PROCEDURE Ptestst (:dbkey char(8) );
BEGIN
UPDATE employees set state = 'BY' WHERE employee_id = :dbkey;
END;
END MODULE;
This will create the module in that database. I also expect that you can use
the alias on the call statement (even though I haven't tried this).
If you can't get this working please submit a BUG report with database
definitions as well as a full script to compile and link.,
Ian
|
| 4953.4 | | CHSR36::LCONS | | Mon Jan 27 1997 05:03 | 19 |
| The exact syntax is:
CREATE MODULE db2.MTESTST LANGUAGE SQL
^^^
PROCEDURE db2.Ptestst (:dbkey char(5));
^^^
BEGIN
UPDATE employees set state = 'BY' WHERE employee_id = :dbkey;
END;
END MODULE;
After that a
CALL db2.Ptestst (:dbkey) is working fine.
Thank's
Louis and Regina
|
| 4953.5 | can we please document this? | 141.148.22.23::ROHR | Oracle Rdb support Switzerland | Mon Jan 27 1997 06:32 | 10 |
| Well, great!!!!!!!!!!
Should I log a documentation bug as we were not able to dig this out
of the documentation or is someone from the docu group listening (with
their eyes...)?
thanks,
Regina
|
| 4953.6 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Mon Jan 27 1997 10:58 | 5 |
| Please submit a documentation BUG report.
thanks,
Ian
|
| 4953.7 | | CHSR36::LCONS | | Mon Jan 27 1997 11:34 | 4 |
| Also we have to hardcode the alias when we create the procedure.
And we can use it only with the alias...
Louis
|
| 4953.8 | No alias needed in procedure definition | chsr38.ch.oracle.com::ROHR | The Packers did it! | Wed Jan 29 1997 07:40 | 5 |
| In fact, as it turns out, there is no need to define the module and the
procedure with an alias, it is sufficient if you call the procedure
with an alias.
/Regina
|