connect error in oracle forms 6i [message #683222] |
Wed, 16 December 2020 03:15 |
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 1522 times)
|
|
|
|
|
|
Re: connect error in oracle forms 6i [message #683237 is a reply to message #683233] |
Fri, 18 December 2020 04:02 |
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 #683240 is a reply to message #683238] |
Fri, 18 December 2020 07:48 |
|
Littlefoot
Messages: 21811 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 #683260 is a reply to message #683251] |
Sat, 19 December 2020 14:20 |
|
Littlefoot
Messages: 21811 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
|
|
|
|