Session in sqlplus?

[Hahu]

Friends,
Good morning,

follows the doubt: How do I handle the SQLPlus the same session of the forms .. how?
Additional information: Forms 6i and Bank 10G and SQLPLUS 8.0

ABS Hahu

[dr_gori]

You can not do that. Each session is unique.
What do you want to do? Maybe someone can help you.

[Hahu]

Speech dr_gori..good afternoon and sorry for the delay in reply .. have with some projects..hihihih

then I was wanting to do some DML's in the same session as the Forms and SQLPlus. .but without giving the commit ... just to see if you are inserting ... understand?

Type like this: In the SQLPlus I do an insert and it appears the information without I give the commit, in the same session .. this is without leaving the session !!
in forms mesmo if I give an insert and get the information they do not appear .. do you know why? : Roll:

ABS hahu

May God bless everyone !!

[dr_gori]

This is because the information is not available for the other sessions until the Commit is given.

Everything you insert in forms or any other application without committing, just gets visible to yourself! (at that session) ... After the Commit, it is available to others.

for you to select in the same session has several forms.
The most common is you put the select of query in the Forms even to test and show a message. (So ??you know what you want from that own sessao).

There are also more "elaborate" ways, such as putting the inserts you want within a procedure Autonomous_Transaction and commit it there. All within this procedure is in a different session. (Be careful with this kind of thing, do not use if you have not given a studying before).

Another way is to use dbms_application_info.set_module to set information that can be seen in V $ session

Select all

dbms_application_info.set_module('SGL003', 'PRC_ATUALIZA_SALDO - INICIO');

Just do select on V $ session that this information will be there.

Any questions, wide aí to galera :-d

[Hahu]

Thanks Dr_Gori ... I'll test ..
abs hahu

[jessica.ff]

Hi everyone, look, I just did not understand a little something:

What information is:
'SGL003'
'PRC_ATALIZA_SALDO - START'

What is passed in these two parameters that these strings was placed
: Roll:

[dr_gori]

It's any text.
This text appears when you make Select in V $ session.
In this way, it is possible to make a simple "debug" type.