Home » Developer & Programmer » Forms » connect error in oracle forms 6i
connect error in oracle forms 6i [message #683222] Wed, 16 December 2020 03:15 Go to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello friends,


I am facing the problem of login error in oracle forms 6i. When run the reports otherwise forms are running properly.Kindly guide me why i am getting the connect error .

Thanks and Regards


Haider
  • Attachment: 54.gif
    (Size: 334.44KB, Downloaded 265 times)
Re: connect error in oracle forms 6i [message #683229 is a reply to message #683222] Thu, 17 December 2020 05:20 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which error? You posted a screenshot which shows nothing (or I don't see it).
Re: connect error in oracle forms 6i [message #683231 is a reply to message #683229] Thu, 17 December 2020 06:00 Go to previous messageGo to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
Sir Error in black circle.connect to login . Infact forms is already longin .
  • Attachment: 54.gif
    (Size: 333.21KB, Downloaded 267 times)
Re: connect error in oracle forms 6i [message #683233 is a reply to message #683231] Fri, 18 December 2020 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe it is about the way you are calling the report. How do you do that?
Re: connect error in oracle forms 6i [message #683237 is a reply to message #683233] Fri, 18 December 2020 04:02 Go to previous messageGo to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
declare
v_role varchar2(30);
begin
select rep into v_role
from users where user_name=:global.user_name;

if v_role='Y' then



Run_Product(REPORTS, :Global.hfc ||'cata.RDF', ASYNCHRONOUS, RUNTIME,FILESYSTEM, 'NULL','Null');

else
message('You are not Athourize to open form');
v_role := show_alert('A1');
raise form_trigger_failure;
end if;
end;

Re: connect error in oracle forms 6i [message #683238 is a reply to message #683237] Fri, 18 December 2020 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read and How to use [code] tags and make your code easier to read.
Indent the code, make sure that lines of code do not exceed 100 characters.

Re: connect error in oracle forms 6i [message #683240 is a reply to message #683238] Fri, 18 December 2020 07:48 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is obviously wrong, is the last two parameters. Should be NULL, without single quotes.

Run_Product(REPORTS, :Global.hfc ||'cata.RDF', ASYNCHRONOUS, RUNTIME ,FILESYSTEM, NULL, NULL);
See if it makes any difference.
Re: connect error in oracle forms 6i [message #683251 is a reply to message #683240] Fri, 18 December 2020 22:39 Go to previous messageGo to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
Yes Sir,

your right error is in this line( Run_Product(REPORTS, :Global.hfc ||'cata.RDF', ASYNCHRONOUS, RUNTIME ,FILESYSTEM, NULL, NULL)Wink I put it your line.but problem is still.picture is attached
  • Attachment: 54.gif
    (Size: 147.49KB, Downloaded 240 times)
Re: connect error in oracle forms 6i [message #683260 is a reply to message #683251] Sat, 19 December 2020 14:20 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm. The 6th parameter is supposed to be a parameter list. If you don't have it, Forms expect a VARCHAR2 so - instead of NULL, try to pass an empty string, e.g.

Run_Product(REPORTS, :Global.hfc ||'cata.RDF', ASYNCHRONOUS, RUNTIME ,FILESYSTEM, '', NULL)
                                                                                  --
                                                                                  this
Re: connect error in oracle forms 6i [message #683261 is a reply to message #683222] Sat, 19 December 2020 23:47 Go to previous message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
same problem not resolve
Previous Topic: forms plsql
Next Topic: when list changed
Goto Forum:
  


Current Time: Tue Nov 30 03:33:48 CST 2021