Search results for query: *

Dave, I'm only calling the procedure from SQL*Plus as a test. Normally it will be called from within another stored procedure. I'm looking to get the directory contents of a folder which sits on the Oracle server rather though - don't know if that makes a difference? Thanks for your continued...

Dave I would like to run the routine from inside a PL/SQL stored procedure (the files are passed to another routine, and the data imported into the db.) Tim

Hi I tried running it and receive the following error. Would you have any idea what the problem is? SQL> exec get_dir_list( '/MRU_MUSIC_FILE' ); begin get_dir_list( '/MRU_MUSIC_FILE' ); end; ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException ORA-06512...

Thanks, never tried it before but will give it a go...

jimirvine, Thanks for your quick response. I'm running 9i unfortunately at the moment - I believe I read dbms_backup_restore.searchfiles is only available in 10g? Thanks, Tim

Hello, Does anyone know how I could use PL/SQL to find all the file names that are in a specific folder? Thanks, Tim

Hello, I'm using FtpWebRequest - I can succesfully FTP files, but can't find a way to set the Proxy server. I've got this far and got stuck: Dim ProxyServer As IWebProxy Dim webProxyUri As New Uri("ftp://my_ftp_proxy") ProxyServer.Credentials = webProxyUri result.Proxy = ProxyServer Any...

Kalisto, Thanks for your reply. Where can I find the Listitem object? Tim

Hello all, I'm currently migrating some code from VB6 to .NET v2. In VB6 I populated the list box with the code below, using Channel_ID as the index. I can't find a way though to do this in .NET. Has anyone any thoughts? lstListBox.AddItem !Channel_Name...

Hi Has anyone got sample code on how to read an XML file using PL/SQL? Thanks in advance Tim

Hi I have a fairly large Access db (about 1GB) that has been working absolutely fine. Now everytime i attempt to edit some code, or insert new code it deletes the line and gives me an 'out of memory' error Looking at the help it says reduce the amount of public variables - I have 10 of them...

Top man - thanks very much Golom. Tim

...BY tblTape_Location.Tape_Number) Max_Tracking_ID ON tblAcquisitions.Tape_Number = Max_Tracking_ID.Tape_Number) LEFT JOIN tblTape_Location ON Max_Tracking_ID.MaxOfTracking_ID = tblTape_Location.Tracking_ID) ON tblStatus.StatusID = tblAcquisitions.StatusID WHERE tblTape_location.Name Like...

...will only ever be 3 values, 4280001, 4280000 or NULL. I spoke to a friend at the weekend, and on his recommendation rewrote it to: SELECT COUNT(*) READY_FOR_TX_CODE INTO v_ready_for_tx FROM PROG_MEDIA_SEGMENT WHERE PROG_MEDIA_ID = v_prog_media_id AND READY_FOR_TX_CODE =...

...is FUNCTION Get_Ready_For_TX_Flag(v_prog_media_id NUMBER) RETURN VARCHAR2 IS v_ready_for_tx NUMBER(9); BEGIN /** Codesc values: 4280000 = Ready for TX 4280001 = Not ready for TX If v_ready_for_tx = 4280001, one or more parts are not ready for tx **/...

This is the SELECT...just how do you turn it into an UPDATE? SELECT med_root.media_sys_id, Aud.Max_Aud_on FROM tbl_bcst_t_media_root AS Med_Root, (SELECT Max(dbo_media_audit.Audited_On) as Max_Aud_on, media_sys_id FROM dbo_media_audit GROUP BY media_sys_id) AS Aud WHERE Med_Root.media_sys_id =...

Based on other posts I've tried ...so no joy... UPDATE tbl_Bcst_t_media_root AS Media_Root SET Media_Root.Activity_Status_Date = (SELECT Max(dbo_media_audit.Audited_On) FROM dbo_media_audit WHERE dbo_media_audit.media_sys_id = Media_root.media_sys_id);

Hi Remou, There is one tbl_bcst_t_media_root.media_sys_id & many dbo_media_audit.media_sys_id I would also need the WHERE clause to join the two tables?

Hello, The following query produces an error 'Operation must be an updateable query'. There are many records in dbo_media_audit to one in tbl_Bcst_t_media_root. How can I get round this please? Thanks in advance, Tim UPDATE tbl_Bcst_t_media_root, dbo_media_audit SET...

Thanks for you help Golom Tim