ORA-00604
Hello List, I have client/server Application in my company The application is working on Forms4.5 Reports2.5 And DB is Oracle8i. I have DMP file which is exported before using oracle 8.0.4 the same version, I tried to import to personal oracle 8.0.4 at my home PC. It's importing successfully without warning I also copied the application (Forms Reports etc) To my personal PC. But the problem is: When I finished every thing and run the application it is working properly but when you query in some forms it will show you this ORA error. POST_QUERY Trigger Raised Unhanded Exception ORA-00604 I checked out this error but I still could not reach The problem. Could any body help... Regards, Ashraf __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle web application
Hi,
excuse me for this delay, here is an example on the display of columns a
table in an oracle database in the form of a table I hope that is going
to help you.
?
print HTMLPRE\n;
print(BODY BACKGROUND=xback01.jpg bgproperties=fixed);
// Initialization of variables
$date1=date(d-m-y);
$date2=gmdate(d-m-y,mktime(0,0,0,date(m),date(d)-7,date(y)));
function entete($titre)
{
print(TABLE width=600);
print(TH align=centerFONT
color=\#FF\B.$Font_trame..$titre./B/FONT/TH);
print(/TABLE);
print(BR);
print(BR);
}
function Init_var_env()
{ global
$Back_ground,$Font_color,$Font_name,$Font_size,$Font_trame,$Font_total;
$Back_ground=#FF;
$Font_color=#000FFF;
$Font_total=#FFCC00;
$Font_name=Arial;
$Font_size=1;
$Font_trame=font color=.$Font_color. face=.$Font_name.
size=.$Font_size.;
}
//call function
entete(Demandes de Mission sur Territoire National);
print(FONT color=\#3300CC\B.Date début :/FONT/B);
print(INPUT TYPE=\text\ NAME=\date2\ SIZE=\15\ VALUE=\$date2\
readonly );
print(FONT color=\#3300CC\B.Date fin :/FONT/B);
print(INPUT TYPE=\text\ NAME=\date1\ SIZE=\15\ VALUE=\$date1\
readonly );
//connect to database
$Connection = ocilogon(user_name,passeword,alias);
//assemble query
$Query =SELECT column_name FROM table_name;
//parse query
$Statement = ociparse($Connection, $Query);
//execute query
ociexecute($Statement);
//display of the table
printTABLE BORDER=\1\;
printTR;
printTH bgcolor=\#CC\FONT color=\#3300CC\N°/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Code
Emett/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Code
recep/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Date
Emission/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Heure
Emission/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Date
Reception/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Heure
Reception/FONT/TH;
printTH bgcolor=\#CC\FONT color=\#3300CC\Etat
Mess/FONT/TH;
print/TR;
//fetch each row
while(ocifetch($Statement))
{
print(TR\n);
//loop over each column
$i = ocinumcols($Statement);
for($i=1; $i = ocinumcols($Statement); $i++)
//print a line like TDSMITH/TD
{
print(TD);
if(ocicolumnisnull($Statement, $i))
{
print(-);
}
else
{
print (ociresult($Statement, $i));
}
print(/TD\n);
}
print(/TR\n);
}
//free the statement
ocifreestatement($Statement);
//close connection
ocilogoff($Connection);
print /PRE;
print HTML\n;
?
LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]
-Message d'origine-
De: Jack van Zanen [SMTP:[EMAIL PROTECTED]]
Date: mercredi 22 mai 2002 03:08
À:Multiple recipients of list ORACLE-L
Objet:RE: Oracle web application
Hi,
I only needed basic functionality of the OCI calls and implemented that
w/o
much problems. The problem was that there are a zillion examples of PHP
MySQL but not with OCI on the internet.
If you have some good examples I will gladly have a look at them and file
them for possible future use
TIA
Jack
SIM/HAOUHACH
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
natrach.dz cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Oracle web
application
[EMAIL PROTECTED]
22-05-2002 15:53
Please respond to
ORACLE-L
Hi,
Excuse my very bad english:-)
can you be more explicit, is what you seek to better understand the
utilization of function OCI, because if it is that I can you to send
examples on what I have made, that will be able surely to help you.
Therefore reply me rapidly:-)
LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]
-Message d'origine-
De:Jack van Zanen [SMTP:[EMAIL PROTECTED]]
Date:mercredi 22 mai 2002 11:13
À: Multiple recipients of list ORACLE-L
Objet: Re: Oracle web application
Hi Aida,
I've build a oracle monitor/admin website using PHP and Apache and
Oracle
repository.It's easy to implement/learn the basics. I had to find out
about
OCI and PHP because there was not much examples on that on the internet
(obvious reason PHP=Free APACHE=Free Oracle= well uhh NOT Free). I
only
needed the basic OCI calls though
Jack
Keith Carney
kcarney@cox-inteTo: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
Re: Stubborn Table
Kevin, As someone mentioned earlier, the first query will not use the index because indexes don't contain NULL values. In the absence of a WHERE clause, a FULL table scan is the only option possible. The second query seems to be utilizing ROWIDs in the subquery, but what good is a column on the inner-table containing ROWID values from the outer-table in a correlated subquery? Expecting ROWID access against the inner table would be reasonable if you were accessing the inner table by ROWID, but you are using ROWID values from the outer table to access a column on the inner table containing ROWID values. No possibility of ROWID access. The way the statement is written, the inner query is a correlated subquery. It will be executed once for each row retrieved from the outer query, using the referenced ROWID value from each row retrieved by the outer row. Only uncorrelated subqueries execute first and return their result back to the outer query, which is perhaps the effect you were expecting? An uncorrelated subquery, as the name suggests, cannot contain a reference from the outer-query, so that it can execute first... The optimizer isn't being stubborn -- it's just correct. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:32 PM Well, it's time to call for the cavalry. I have a table where the optimizer stubbornly insists on doing full table scans for practically every operation in spite of the fact that full table scans have gruesome performance. Every hint I have tried has either been ignored or doesn't help (and yes, I have used hints before and have carefully checked my syntax). The only way I have gotten the optimizer to even use an index on one query was to jam the session settings OPTIMIZER_INDEX_CACHING=100 plus OPTIMIZER_INDEX_COST_ADJ=1 which is not a healthy way to do things. I would appreciate some help in psychoanalyzing the optimizer. Oracle 8.1.7.3 on Solaris 2.8, all files on a single volume RAID-5 array (I know, I know but I can't do anything about it at the moment). MDMA_INPUT_FILE is a high transaction table used for data loading and validation. The table is badly denormalized due to decisions made long before I started working here. It has 15 indexes to support the validation GUI (yes, I know, lots of indexes on a high transaction table is insane and I have plans to deal with that in a month or two). At the moment, the table holds over 800K rows. The table has been analyzed. Here are a couple examples of loony optimizer behavior: ### SELECT Record_Type, Archive_Input_File FROM MDMA_Input_File GROUP BY Record_Type, Archive_Input_File SELECT STATEMENT Hint=CHOOSE 162 7500 SORT GROUP BY 162 6 K 7500 TABLE ACCESS FULL MDMA_INPUT_FILE 839 K 31 M 1882 There is a valid index where these two columns are the first of 5 columns. I've tried most permutations of INDEX hints and they are all ignored. Actually, this statement stemmed from working around a problem of reading the full table ordered by the 5 index columns. The optimizer chose to do a full table scan plus sort (with resultant RAID-5 ugly performance). Apparently, it feels the sort would be quicker than index access -- which might be true on a non-IO bound system. ### UPDATE mdma_input_file mif SET partial_day_hold = :b1, ok_to_process = :b2, vee_usage_end = to_date(:b3) WHERE EXISTS (SELECT 1 FROM st_vee_input_file WHERE mif.rowid=mdma_rowid) st_vee_input_file is a session temporary table with 96 rows. UPDATE STATEMENT Hint=CHOOSE 41 K 1882 UPDATE MDMA_INPUT_FILE FILTER TABLE ACCESS FULL MDMA_INPUT_FILE 41 K 409 K 1882 TABLE ACCESS FULL ST_VEE_INPUT_FILE 82 574 7 Unless I can figure this out, I foresee reading the temp table into an array then doing the update in a forall loop. Shouldn't have to do this much coding to work around the optimizer. Thanks for any help you can give (or sympathy if help is unavailable), Kevin Kennedy First Point Energy Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
O9.2.0.1.0 linux enterprise-manager
hi folks installed on a RedHat 7.3 linux the latest Oracle Database 9.0.2.0.1 - they forgot again a $(LINKLDLIBS) in the $ORACLE_HOME/ctx/lib/env_ctx.mk, which lead to an error during installation. once inserted installation went on fine. experienced the missing ientry just on rh7.3 - not on rh7.2 where it was previously installed - but THERE IS A PROBLEM with ENTERPRISE MANAGER. it installs fine and works, detects all SunOS-5.8, NT 5.0 and linux based nodes. when connecting to SunOS or linux there is no problem. but when i connect to NT5 nodes - that were previously detected w.o. error - then i get a: ORA 12545 - Connect failed because target host doesn't exist - same procedure on a SunOS5.8 based EM gives no problem. has anybody any idea? other thing is: w've a 9.2 database on a XP - hostname is not the same as nameserver hostname. this node can neither be discovered nor connected from EM. no problem from console. again: has anybody any idea? these arre not urgent matters - but for curiosity i check out! kr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Jr.DBA, Mid level DBA, Sr.DBA
I beg to differ. All Real DBA's should be platform independent. (and if that platform comes from M$FT, they should probably be undergoing intense therapy). -- James [EMAIL PROTECTED] wrote: Better run like WIND!! All Real DBA's use HP. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 5/31/2002 11:01 AM AIX? Come on all really senior DBAs work on SUN (ducking and running broken field pattern :) ) --- Freeman, Robert [EMAIL PROTECTED] wrote: A few thoughts... SNIP Really Sr. DBA: Is busy installing the latest version of Oracle on AIX, and SNIP -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
Peter Barnett wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] Much of this may have already been said, but, here's my $0.02 ($0.012 after taxes): Generally, the term Applications DBA (note the plural form of Application there), refers to one who is concerned with the Oracle Applications (or Oracle Financials, or the Oracle Cooperative Applications, or the Oracle E-Business Suite, or whatever they're calling the bundle this week). That said, there is a pretty significant difference between an Applications DBA and a Regular DBA. Mostly, the Applications DBA would tend to do less of the data-modeling and, in some degree, less of the developer-handholding than a Regular DBA. Also, prior to the advent of a simple little trick they decided to give a complex-sounding name server-partitioning, the Regular DBA would probably have been much more familiar with the *newer* features of the RDBMS. (The Oracle Apps being such a behemoth that they generally don't (didn't) make use of many of those features). For example: Roles, Defined referential integrity constraints (relatively new to the Apps), partitioned tables/views, star schemas, replication, etc. Although, like anything, your degree of exposure to these features may somewhat depend on the systems you're supporting/implementing. Now, as to a Production vs. a Development DBA (Development probably being a more appropriate term in most cases). A Production DBA is generally more concerned with the overall availability and stability of the system (Backup/Recovery, Performance [identifying bad code and bashing the developer over the head with it], datafile placement, Failover, etc.). A Development DBA probably has more direct input into the design of the system (Normailzation, ERDs, tuning bad code before it goes into production). The Development DBA also probably has to/gets to deal with the Developers more frequently. So, IMHO, a good Production DBA would more likely have a Systems Administration background. While a good Development DBA would more likely have a Development background. And, a Great DBA should have some of both. -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Jr.DBA, Mid level DBA, Sr.DBA
What's wrong with M$FT. Most people use it : The majority cannot be wrong. What's wrong with you guys. If it works, then use it. If you can make it work, then use it. If you can pretend that it works, then use it too. ltiu On Saturday 01 June 2002 14:53, you wrote: I beg to differ. All Real DBA's should be platform independent. (and if that platform comes from M$FT, they should probably be undergoing intense therapy). -- James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
