| Call Procedure & Mouse Pointer [message #80539] |
Wed, 09 October 2002 06:47  |
Nishant
Messages: 20
Registered: August 2001
|
Junior Member |
|
|
Hi,
There are two users in one database, User1 and User2.
Through D2k, i am connected by user1 and want to call procedure of User2 without hard-coding User2. i will pass User2 as a procedure.
how to do?
Is it possible to change Mouse pointer runtime like change from default to Hour Glass or vice-versa?
Nishant
|
|
|
|
| Re: Call Procedure & Mouse Pointer [message #80552 is a reply to message #80539] |
Thu, 10 October 2002 22:00  |
|
|
user2's procedure
You will need to use dynamic SQL in some form, either EXECUTE IMMEDIATE or DBMS_SQL on the server side, or FORMS_DDL, DBMS_SQL, EXEC_SQL from the client.
Simplest would be :
FORMS_DDL('begin '||:v_user||'.proc; end;');
However, if you are wanting variables passed out, then have a look at EXEC_SQL.
Mouse_point : set_application_property cursor_style
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
