V6 Forms 3.0 call to a V7 stored procedure
Date: Sat, 24 Sep 1994 05:59:54 GMT
Message-ID: <1994Sep24.055954.5248_at_merlin.hgc.edu>
I am involved with an Oracle 6 -> 7 conversion project. I am a PowerBuilder person but am helping out with this Oracle project. Unfortunately, there's no Forms expert around to advise.
We have a SQL*Forms 3.0 applic. that worked with the Oracle 6 database. To run it with the Oracle 7 database, we want to call the stored procedure SYS.DBMS_SESSION.SET_ROLE () to take advantage of the Grant Role offerings of V7.
If so, how would we do so? I tried:
execute SYS.DBMS_SESSION.SET_ROLE ('SUBS_USER IDENTIFIED BY SUBSPWD');
and also,
SYS.DBMS_SESSION.SET_ROLE ('SUBS_USER IDENTIFIED BY SUBSPWD');
neither worked, I was thrown out of Forms. Since I am very new to Forms
I may have been thrown out for an even more basic problem. Maybe someone
could help me with that one too -
I was adding this call to the Key-Startup trigger. I am running Oracle 7
on the Netware platform. To edit this Key-Startup trigger, I used the
Forms pull-down option: Trigger. I then went to the Trigger Definition
Form for Key-Startup and tabbed to the Trigger text box. After adding
my call to end of the existing trigger code, I hit F10 (for Accept?).
Maybe I should have hit some other keystroke to compile this trigger text.
Could you tell me the best way to compile the trigger code? And once it
is compliled, should I do a Generate and then a Run?
One other question:
This Forms Applic. has a SQL*Menu frontend. I saw something funny in SQL*Menu when I went to check the "command line" code that each SQL*Menu option executes. Most just say "runform xxx &uw&pw". But one of them says "runform xxx &uw&pw ^ runform xxx schema/schema x_at_:orasrv" (or somethign close to that...) My question is, what does the ^ character mean? Looks like two different runform commands might be executed by that one particular menu option. Am I close?
I apologize for asking such basic questions. The person that wrote this applic. is long gone. I did browse the reference manuals but still wasn't able to find my answers.
Many thanks for any insights you can share with me. Feel free to email me directly or post here.
--Received on Sat Sep 24 1994 - 07:59:54 CEST
------------------------------------------------------------------------
Janet Traub The Hartford Graduate Center trau2349_at_hgc.edu Hartford, CT
------------------------------------------------------------------------