Recent content by comgrit

Hi, I'm trying to create a cursor within a procedure that have a tablename as parameter. This example is showing what I intend to do: create or replace procedure test (p1 varchar2) as cursor c1 (tabname IN varchar2) is select distinct prod_code from tabname; c1_rec c1%ROWTYPE...

Hi, I have a silimar request - getting an XML data file and would like to import it into a table in an Oracle database. Any advise of where to start with. Thanks in advance. Comgrit

Thanks for the advice. However, the issue is not really the code itself. I finally found that there are something wrong in the underlying RDBMS access. now it is solved. Without changing this code.

Hi, I'm implementing a J2EE application that has been run successfully in QA. Now I'm moving it to production. The same JSP that worked in QA do not work in production. Here's error message. ========================================= 500 Internal Server Error OracleJSP...

Greetings, I have a problem about inconsistency of 2 environment. The system consist of : QA Environment: Oracle RDBMS 8.1.7.4 (in #1 HP-UX box) Oracle 9IAS running J2EE 1.2 (in #2 HP-UX box) Production Environment: Oracle RDBMS 8.1.7.1b (in #3 HP-UX box) Oracle 9IAS running J2EE 1.3 (in #4...

Thank you very much. This is really help as to get me starts. I can take care of the rest.

I'm trying to extract the filename and date/time stamp of each file in YYYYMMDDHHMMSS format. For example $ ls -l total 26 -rw-rw-r-- 1 idwcq idwcq 0 Jun 3 13:30 os30_mdai_fw.stopfw drwxrwxrwx 2 idwcq idwcq 1024 May 14 23:58 temp drwxrwxrwx 2 idwcq...

You can find all the detail explaination of the SQL*Plus SET command in the SQL*Plus User Guide and Reference - one of the Oracle documentation. in the reference -> command reference section. comgrit

Sometime I found that using GROUP BY clause provide me more flexibility over DISTINCT

What I normally do with this situation is to create the tmp_site in which it has no referencial integrity. Once loaded, then I assign the network_id, and insert from tmp_site to site. You can also do it via SQL*Loader - but I found that working with sql scripts is more easier (at least for...

i guess you link the Oracle table through ODBC, if that's the case, when you link the table, Access will ask you to select some of the field to be use as primary key on Access. You have to choose the unique combination of the key so that when ODBC send update request to Oracle, it will know...

You need to use Oracle Discoverer Admin 4.1 to first create the EUL (End User Layer) before you can use the Discover to create the query against your Oracle8. The Admin edition is a separate Windows Application.

hard reset will do the work - but only temporary, after a while it will become out again. Depends on how bad the connector is.

this is quite normal for an old (more than 2-3 years) unit. It has something to do with the battery connection and/or display connection inside the unit. I have mine resolved by send it to the service shop who has expertise in cracking the Palm Unit. Not quite sure if you would have that...

check the 'Prefs' application, then choose the HiRes tab, and make sure that the 'Enable High Resolution Assist' has the check marked before it.