OraFAQ Forum: Forms » connection problem

Home » Developer & Programmer » Forms » connection problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connection problem [message #234867]

Thu, 03 May 2007 06:31

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)

Report message to a moderator

Re: connection problem [message #235104 is a reply to message #234867]

Fri, 04 May 2007 01:36

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

Help me urgent............................?

Report message to a moderator

Re: connection problem [message #235168 is a reply to message #235104]

Fri, 04 May 2007 04:04

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: connection problem [message #235183 is a reply to message #235168]

Fri, 04 May 2007 04:27

pragatimathur
Messages: 42
Registered: July 2006
Location: DELHI

Member

write this in on-logon trigger:
logon('scott','tiger'||'@'||'test');

Report message to a moderator

Re: connection problem [message #235213 is a reply to message #235183]

Fri, 04 May 2007 06:25

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

Report message to a moderator

Re: connection problem [message #235470 is a reply to message #235213]

Sun, 06 May 2007 11:33

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	which trigger fires when we give execute query from menu?
Next Topic:	passing parameter from one form to many ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 13 06:42:41 CST 2024