| sql/pl-sql execution platform in Form 6i (merged 2) [message #504048] |
Thu, 21 April 2011 04:59  |
kamransagri
Messages: 13
Registered: May 2006
Location: india
|
Junior Member |
|
|
Hi,
I have an understanding that the code written in Forms 6i will be executed by the oracle forms 6i run time on the client machine whether it be a sql/plsql .
kindly confirm my understand or guide me if there is any other thing .
e.g i am using the following query in the procedure( of forms 6i interface ).
insert into emp_remote
select ename from emp@db1;
so where the above query would be executed , on client machine or server named db1.
|
|
|
|
|
|
| Re: sql/pl-sql execution platform in Form 6i [message #504061 is a reply to message #504054] |
Thu, 21 April 2011 06:40  |
kamransagri
Messages: 13
Registered: May 2006
Location: india
|
Junior Member |
|
|
let my rephrase my question ,
whenever we use form 6i to run application then where does the code get executed on server / on client or it depends on the type of code as you said insert statements get executed on server.
is there any document which defines the architecture of forms run time i-e which type of code executed where ?
kind regards.
|
|
|
|
|
|
| Execution of SQL [message #504088 is a reply to message #504048] |
Thu, 21 April 2011 08:37 |
kamransagri
Messages: 13
Registered: May 2006
Location: india
|
Junior Member |
|
|
Hi,
I am using forms 6i on windows xp to connect db 10g ,I wanted to know where the execution take place of code written in Forms 6i.
whether sql/pl-sql code written in forms client is executed on client machine to in the database server.
if is there any resource to look this matter into detail then kindly refer it .
kind regards,
Kamran Sagri.
|
|
|
|
| Re: Execution of SQL [message #504089 is a reply to message #504088] |
Thu, 21 April 2011 08:44 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
I believe it is the client side. It has it's own engine. For example, you cannot use analytics in 6i or even CASE statements I believe (this is all just from memory, so I cannot be sure), even if you connect to a 10g database.
|
|
|
|
| Re: Execution of SQL [message #504092 is a reply to message #504089] |
Thu, 21 April 2011 08:51 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
@kamransagri - please don't cross-post. I've merged your new post into the original.
I really don't believe sql is executed on the client. It may well be syntax checked - since the client does run some stuff (forms built-ins if nothing else) so has to be able to work out for itself what is sql and what isn't. Hence the inability to run case statements directly in 6i.
However, from memory, if you run a db trace on a forms session you'll see all sql statements as is. So they're being run by the DB. Since they're accessing DB objects it really can not work any other way. You can't load the tables up into the client and access them from there.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
