| win_api_shell.winexec ORA-01403: no data found [message #521134] |
Fri, 26 August 2011 09:30  |
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 #639709 is a reply to message #639551] |
Tue, 14 July 2015 10:11  |
 |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
