Re: Problem with calling sqlplus from forms

Madhusudan Lingegowda (ml2_at_Ra.MsState.Edu) wrote:

: Hi all,


: 	I am trying to call sqlplus command from the forms trigger 

: 	key-nxtblk.

: 	I am typing the following command

: 	host('sqlplus usename/passwd _at_test_report');

: 	It is giving following error


: 	frm-40811 shell command had error.




Hi Madhusudan,

Your posting does not contain a lot of information, but here are a couple of 
things you could check:

1. Your shell cannot find sqlplus because the path has not been set correctly (very likely) 2 Maybe the '_at_' sign is interpreted by your shell as some funny control character (depending on your OS and/or type of shell) 3 The username or the password contain spaces or other nasty characters 4 If you are running MSDOS, you should use ohost() in stead of host 5 Your command string is too long to be interpreted by the shell (on MSDOS this is somewhere around 100 characters)

Good luck,
Olaf

--
Olaf vd Geest                              Oracle Corporation
ogeest_at_nl.oracle.com                       Rijnzathe 6
                                           De Meern
----------------------------------------------------------------
*****        This is not official Oracle Support           *****
***** These opions are mine and not those of my employer   *****
----------------------------------------------------------------