Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RobNisbet
  • Content: Threads
  • Order by date
  1. RobNisbet

    Oracle stored procedure command boolean parameter

    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...
  2. RobNisbet

    SET command

    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...
  3. RobNisbet

    select user from dual ?

    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...
  4. RobNisbet

    select user from dual

    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...
  5. RobNisbet

    Last working day of the month

    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...
  6. RobNisbet

    Preloading of images

    Hi ppl, Please can someone knowledgeable help..... I have a set of pages, which all use the same set of images. I have noticed that there is javascript that preloads them in each and every page. Does this mean that rather than use the browser cache, the pages are forced to retreive and save the...
  7. RobNisbet

    Total of a RS field

    Hi People, I've got this bit of code that shows all my records on an asp page fine, so now I want to add a total at the bottom. I try to add a field to a variable inside the loop but always get zero for the total for some reason. Is there a better way, there doesnt seem to be a method for...
  8. RobNisbet

    Calling Oracle Stored FUNCTION from ASP

    Hi, I am having probs calling my Oracle function. I am aware of the whole process of calling an Oracle SP from ASP and returning a recordset, however this one is slightly different. My Stored function goes like this... FUNCTION next_nah_status (p_status IN NUMBER, p_change_code in VARCHAR2...

Part and Inventory Search

Back
Top