Recent content by RobNisbet

Please can someone have a look at this ! There must be someone out there who has used a boolean parameter ? Thankx!

I am using a command object in asp to call a db (oracle) stored proc.I have hit a stumbling block with a boolean data type parameter tho.. PROCEDURE x (.... p_2 in BOOLEAN,...) has a boolean parameter...but trying all sorts of ways of passing eg. Cmd.Parameters.Append Cmd...

Stranger still .. but resolved set /A M= 8 set /A M= ( %M% +1) echo Month is %M% *this said invalid lala set /A M= 8+1 echo Month is %M% *but this worked set /A M= 8 set /A M= %M% +1 *And this worked !! which is the one I needed ! BUT when I put the string 08 from the date into M it doesnt...

It sure is.... about the set command in isolation though .. set /A %M= 8 works fine set /A %M= (8+1) gives the error. Is that the same with you ? Cheers

Hi, Thanks for responding ....but I get a Missing Operard error, and M is blank. Any ideas why ? (or an easier way of doing the whole thing?!) Thanks !

Hi I have a little piece of a batch file which works out the number of last month...however I am struggling to get the set command to work properly to remove 1 from the number. Anyone able to make it work ? Thanks.. for /F "tokens=2-4 delims=/- " %%A in ('date/T') do ( set MO=%%B...

Thanks, but sorted now - it was the characterset in 9i not supported. We are moving to 6i which works OK!

The 9i DB has charset WE8ISO8859P15 (Euro compliant), whereas the old DB has WE8ISO8859P1, but I don't see why this causes a problem since I am not using the new characters, just selecting username from dual ?? Would the best solution be to upgrade Oracle client to 9.2 ? Thanks again Rob

I am using forms 6.0.5.34.0 unfortunately, charset is the same ! Cheers !

Hi, I am just testing my forms 6 app against a new 9i database (works fine on 8i). I don't get far - the following simple proc causes a ORA-24365 error (error in conversion of a multi-byte character) This works OK in 8i, plus works OK in SQL*PLUS in 9i - so why does Forms not like it in 9i...

Hi, I am just testing my forms 6 app against a new 9i database (works fine on 8i). I don't get far - the following simple proc causes a ORA-24365 error (error in conversion of a multi-byte character) This works OK in 8i, plus works OK in SQL*PLUS in 9i - so why does Forms not like it in 9i...

Hi, will that work inside a dbms_job command ? At the moment I use exec dbms_job.isubmit(1,my_code;',(trunc(last_day(sysdate))+18/24), 'trunc(last_day(sysdate))+18/24',false); I think that it needs to be a single line function based statement (but annoyingly not decode!) Sem, so you mean...

Thing is, cannot use decode in the dbms_job.isubmit. Any ideas without using decode ? ORA-06550: line 2, column 53: PLS-00204: function or pseudo-column 'DECODE' may be used inside a SQL statement ORA-06550: line 2, column 2:

Ah, clever. Thanks!

Hi, I am trying to run a job on the last working day of the month - I currently use trunc(last_day(sysdate))+18/24 as the code, which finds the last day of the month fine. The problem occurs when the last day of the month is a Saturday or Sunday - if that occurs, I need to then bring the job...