Home » Developer & Programmer » Forms » connection problem
connection problem [message #234867] Thu, 03 May 2007 06:31 Go to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
sir,
i have a tabpage form,my all work is ok but a new problem generated,
i have created a connection procedure because i want when a user will click
the form(exe file) then that form will automatically connected to the data base,
all is ok,but this form cannot feach any data to the data base or
no input support............/

this is my procedure

PROCEDURE getData(connection_string IN VARCHAR2) IS
connection_id EXEC_SQL.CONNTYPE;
bIsConnected BOOLEAN;
cursorID EXEC_SQL.CURSTYPE;
nIgn PLS_INTEGER;
sqlstr VARCHAR2(1000);
BEGIN

connection_id := EXEC_SQL.OPEN_CONNECTION(connection_string);
cursorID := EXEC_SQL.OPEN_CURSOR(connection_id);
bIsConnected := EXEC_SQL.IS_CONNECTED(connection_id);


EXCEPTION
WHEN EXEC_SQL.PACKAGE_ERROR THEN
TEXT_IO.PUT_LINE(' connection open failed ');

END;

i have called this procedure ON-LOGON Tigger
getData('scott/tiger@test');
please anybody give me a better solution..how i retaive data or any input in data base
by using form....

IqubalMasud..(Dhaka.Bangladesh)
Re: connection problem [message #235104 is a reply to message #234867] Fri, 04 May 2007 01:36 Go to previous messageGo to next message
oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka
Member
Help me urgent............................?
Re: connection problem [message #235168 is a reply to message #235104] Fri, 04 May 2007 04:04 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So call the Oracle support and pay them for the solution.

Or would you rather wait a little bit longer until someone who knows how to do that and has enough spare time to explain it to you answers your question for free?
Re: connection problem [message #235183 is a reply to message #235168] Fri, 04 May 2007 04:27 Go to previous messageGo to next message
pragatimathur
Messages: 42
Registered: July 2006
Location: DELHI
Member
write this in on-logon trigger:
logon('scott','tiger'||'@'||'test');
Re: connection problem [message #235213 is a reply to message #235183] Fri, 04 May 2007 06:25 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
create a push button and write the code in whe-button-pressed ...
AT
Re: connection problem [message #235470 is a reply to message #235213] Sun, 06 May 2007 11:33 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Reported message
Reported By: oracleproblem On: Sun, 06 May 2007 17:34 In: Developer & Programmer Forms connection problem

Reason Thanks for your better solution......................Masud Raihan(Dhaka.Bangladesh)

Please, do not report messages for such a purpose - use the "Reply" button instead.
Previous Topic: which trigger fires when we give execute query from menu?
Next Topic: passing parameter from one form to many ?
Goto Forum:
  


Current Time: Tue Dec 06 04:30:48 CST 2016

Total time taken to generate the page: 0.13767 seconds