Alaska Cowboy
asked on
how can I debug with Pl*Sql Developer when the procedure reads a file from Unix ?
I develop in Pl*Sql, then run the procedures via Unix / Sql * Plus, the program reads flat files on Unix.
But how do I debug this, since the Pl*Sql Windows session doesn't recognize Unix ? Do I put the file on Windows ? If so, how do I read that ?
I read the Unix files like this:
fh_inp := UTL_FILE.FOPEN([UNIX FILE LOCATION],'fep_clm_clm_lin e_nwr76579 .dat','R', 2000);
UTL_FILE.GET_LINE (fh_inp, input_rec2);
But how do I debug this, since the Pl*Sql Windows session doesn't recognize Unix ? Do I put the file on Windows ? If so, how do I read that ?
I read the Unix files like this:
fh_inp := UTL_FILE.FOPEN([UNIX FILE LOCATION],'fep_clm_clm_lin
UTL_FILE.GET_LINE (fh_inp, input_rec2);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sdstuber, ok, thanks.
are you saying I should be able to debug normally ? I always thought I couldn't debug from Pl*Sql Developer when reading a flat file from Unix.
are you saying I should be able to debug normally ? I always thought I couldn't debug from Pl*Sql Developer when reading a flat file from Unix.
shouldn't be a problem, you can't "step into" the utl_file procedures themselves anyway, so the location of those files is irrelevant.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
stdstuber and choukssa, ok, good, I guess I can do it. and I should have tried it first, but I just had it in mind that I can't do it. will give it a whirl, thanks.
ASKER
oops, guess I should have tried it first. but I had it locked in my brain it couldn't be done.
so it worked great !
Thanks.
so it worked great !
Thanks.
you'll have to put your files on the unix server.