Search results for query: *

Thank you guys! That's exactly what I told my boss, but he wants it in writing, because HIS boss is asking. Of course, I told him no official info is available, but you guys are awesome. Giving you both a star. Nunina [gorgeous] IT Manager San Juan, PR www.viveconendometriosis.com

Hi Guys! Thanks in advance for your support. How long can my WLS app server run without having to bounce it? Is there an Oracle recommended period of time? I cannot find that information anywhere. I've had my servers run for 6 months flawlessly before having to bounce. We recently have...

No Dian, no luck at that site. I can't even load that page! Nunina [gorgeous] IT Manager San Juan, PR www.viveconendometriosis.com

Hi Guys! I haven't written in a while, but I guess I need your help on this. I've been working on this non-stop for the past 2 days and I am just about to give up. I have to create a datasource in JBoss running on Windows 2k3. Of course, I have no idea how to do this, since there's no...

Hi All Let's refer to thread393-1451323. I am having the same issue mentioned on that thread, where when I attempt to export the universe I receive an error with something like "unable to convert unv to unw", and then the export fails. In addition, when I look into the table browser and click...

Hi guys, I am creating a site that can connect to a MySQL, Access or SQL databases. The databases are located at a remote site (i.e. hosting site) and I have very limited information on them, other than the DSN and connection strings. I have created an asp page for user registration. I can...

Hi Guys! I have a table that has 47,000,000 records. I need to get the first 1,000 rows in descending last_modified_date order. I get as far as this: select rownum, location_id, last_modified_userid, last_modified_date from location where rownum <= 1000 order by last_modified_date desc...

Hi Guys, I have been administering an application deployed in WebLogic Server 8.1.5 for the past year. The web server runs in Windows 2003 and the JDBC connection is Oracle. Once in a while, the application begins to have issues. Most of the time, the error it shows in the main (application)...

Hi itsp! Well, the thing is that the batch file is already created, and it runs perfectly. It copies a bunch of files into a specific folder, and installs an application. Within all the files copied, one of them is an .exe. I would like to create a shortcut on the desktop for THAT .exe...

Hi Guys! I have a cmd that is installing some files and registering dlls in a machine. I need to create a shortcut for an .exe file that resides in the installation folder and places it on the desktop. Is there a DOS command that I can use for this? As usual, thanks a bunch!! Nunina...

Thanks a bunch, JP!! It worked perfectly!! Now, if you kindly explain what the /s does, I'll give you the star! Nunina [gorgeous] Cognos BI Administrator San Juan, PR

Hi Guys! I have a .cmd that is supposed to extract files and copy them into another location, as well as register some dlls. When the registering is complete/successfull, a window shows the status of the register (successful, etc.) and has a little OK button. I don't want to see that little...

Thanks for all your input. I think that I will approach this using non-packaged, user-defined procedures from the command script as you suggested. My concern was that the executions might be parallel, thus rendering incorrect results. I will post back the results of my little project in a few...

Sorry, Mufasa. Had to make it a 2 SP package, since the SP def was too long for SQLPlus. Well, then... Let me see if I understand, and you might be able to give me some pointers. The purpose of creating the package is to invoke it from a command script. It may just be easier to call each...

Thinking about it, could it be a GRANTS issue? Gracias! Nunina [gorgeous] Cognos BI Administrator San Juan, PR

...for all your help. The error is executing the package. Maybe I have the execute syntax wrong? SQL> exec pkg_info; BEGIN pkg_info; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00221: 'PKG_INFO' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL...

Mufasa, Line 2 is: For the specs: PROCEDURE SP_INFO_EXTRACT; For the body: PROCEDURE SP_INFO_EXTRACT IS Nunina [gorgeous] Cognos BI Administrator San Juan, PR

[bigsmile] Muchas gracias. Aqui tienes una estrella. But, we still have a problem somewhere, because although it compiles, I still get the error: ORA-06550: line 2, column 16: PLS-00302: component 'PKG_INFO' must be declared ORA-06550: line 2, column 3: PL/SQL: Statement ignored Nunina...

...V_TNAME:='EXTRACT_INFO_BK_' || to_char(trunc(sysdate),'YYYYMMDD')|| ''; V_CREATAB:='CREATE TABLE INFO_EXTRACT.' || V_TNAME || ' AS SELECT * FROM EXTRACT_INFO_NEW'; EXECUTE IMMEDIATE V_CREATAB; EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Error Exception ...