Home » Developer & Programmer » Forms » win_api_shell.winexec ORA-01403: no data found (Oracle Applications, Forsm6i, Client:Windows Xp, Server: Linux)
win_api_shell.winexec ORA-01403: no data found [message #521134] Fri, 26 August 2011 09:30 Go to next message
m_dk29
Messages: 5
Registered: October 2009
Junior Member
I have requirement to open application on client desktop (Server is Unix) using D2KWUTI from forms 6i and Database 10g. I don't have the luxury of using all functions available on Forms 9i/10g since there is no standard D2KWUTIL for forms 6i.

Imported libraries into form and push button has following code.
d2kwut60.dll is placed in c:\windows\system32\ and path is set in environment variable.

declare
iConst pls_integer := 'SW_SHOWNORMAL';
begin
win_api_shell.winexec('c:\windows\system32\notepad.exe',iConst,FALSE);
exception when others then
message(sqlerrm);
end;


No errors when compiled in server, when form is opened from oracle applications and submit button is pressed i get the below error.

ORA-01403: no data found

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

I changed to different applications to open but no luck.

host command is used, no error but it doesn't do anything. I think host executes on the server side. I need the application to execute and open on the client machine.

Help is appreciated.
Re: win_api_shell.winexec ORA-01403: no data found [message #521170 is a reply to message #521134] Fri, 26 August 2011 13:05 Go to previous messageGo to next message
joy_division
Messages: 4823
Registered: February 2005
Location: East Coast USA
Senior Member
I am not sure completely what you are trying to do, but if you have WebUtil installed, you can simply do something like this:

client_host('cmd /c start /d notepad.exe');
Re: win_api_shell.winexec ORA-01403: no data found [message #521205 is a reply to message #521170] Fri, 26 August 2011 14:55 Go to previous messageGo to next message
m_dk29
Messages: 5
Registered: October 2009
Junior Member
we are on forms 6i, cannot use client_host
Re: win_api_shell.winexec ORA-01403: no data found [message #521732 is a reply to message #521134] Thu, 01 September 2011 10:31 Go to previous messageGo to next message
m_dk29
Messages: 5
Registered: October 2009
Junior Member
any help guys?
Re: win_api_shell.winexec ORA-01403: no data found [message #639526 is a reply to message #521134] Thu, 09 July 2015 03:52 Go to previous messageGo to next message
macikacz
Messages: 3
Registered: July 2015
Junior Member
I have the same problem when I try run 64 application on x86 OS. But when I try run notepad ewerythings is ok.
Re: win_api_shell.winexec ORA-01403: no data found [message #639547 is a reply to message #639526] Thu, 09 July 2015 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 21367
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does it make sense, running a 64-bit application on a 32-bit operating system? I don't think so (but I'll read your explanation).

Besides, is it an Oracle problem, or did you hit this page by Googling around for the error you got?
Re: win_api_shell.winexec ORA-01403: no data found [message #639549 is a reply to message #639547] Thu, 09 July 2015 09:27 Go to previous messageGo to next message
macikacz
Messages: 3
Registered: July 2015
Junior Member
I found this page by google when I had the same problem. When I run x64 app on x86 OS I should have message like 'xxx.exe is not a valid win32 application' not ORA-01403.
Re: win_api_shell.winexec ORA-01403: no data found [message #639551 is a reply to message #639549] Thu, 09 July 2015 10:43 Go to previous messageGo to next message
macikacz
Messages: 3
Registered: July 2015
Junior Member
And I didn't know that is x64 application. I launched it using win_api_shell.winexec like many others applications and I didn't expect ORA-01403. But when I wrapped it by bat script I had appropriate message.
Re: win_api_shell.winexec ORA-01403: no data found [message #639709 is a reply to message #639551] Tue, 14 July 2015 10:11 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
This is a confusing thread...
Quote:
I have requirement to open application on client desktop (Server is Unix) using D2KWUTI from forms 6i and Database 10g. I don't have the luxury of using all functions available on Forms 9i/10g since there is no standard D2KWUTIL for forms 6i.

Are you using Forms 6i or Forms 9i/10g? If Forms 6i, is your application deployed via Client/Server or Web Deployed?
Quote:
we are on forms 6i, cannot use client_host

Client_Host is a WebUtil function and replaces the standard HOST() built-in for web deployed applications. If you are Client/Server - you can use the HOST() built-in.

I'm confused with regards to your Client OS...what is your client OS version and is it 64 or 32-bit?

Obviously, if your client is a 64-bit OS you will not be able to use a 32-bit call to a 64-bit API.

Quote:
ORA-01403: no data found

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

You have 2 errors here. The first, ORA-06502 is a PL/SQL Numeric Value error and is the core error, in my opinion. The ORA-01403: No data found error is the default error when an a non-Oracle method/built-in is called and it returns an error. Therefore, you need to pursue the ORA-06502: PL/SQL Numeric or Value Error.

Are you sure the PLS_INTEGER is the correct data type for the iConst variable? Have you tried just using a NUMBER data type?

Have you tried using the HOST() built-in to open Notepad.exe instead of the win_api_exec.winexec() method?

Craig...
Previous Topic: Forms 10g to 11g upgrade getting FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
Next Topic: Message bar missing from oracle forms application
Goto Forum:
  


Current Time: Sat Feb 24 09:13:39 CST 2018

Total time taken to generate the page: 0.03755 seconds