Unique IDs in a VIEW

From: Stacy Mader <smader_at_atnf.csiro.au>
Date: Sat, 25 Mar 2000 00:13:22 GMT
Message-ID: <38DC04A2.D6A59143@atnf.csiro.au>

Greetings all.

I'm using a perl code to access an Oracle (V7.3.3) VIEW, which consists of to UNIONED tables. Now, the original perl code is designed to use the unique id belonging to every row in the entire database (that's the ROWID). After playing around with the code, I found that VIEWs don't contain that information, or at least not in the same way as TABLEs.

Is there a way to create a VIEW with such an unique id?

The SQL statement the perl code uses is:

$sql_statement = "select $db.$DBROWIDNAME, ";

and the resulting error message is:

Can't prepare statement: ORA-01445: cannot select ROWID from a join view without a key-preserved table (DBD: error possibly near <*> indicator at char 78
in 'select report_response.rowid, FAULT_NO, ISSUE, RESPONSE_NO, RESPONSE from <*>report_response where (ISSUE like '%perseus% %crash%')').

SQL: select report_response.rowid, FAULT_NO, ISSUE, RESPONSE_NO, RESPONSE from report_response where (ISSUE like '%perseus% %crash%')

Thanks alot.

Stacy. Received on Fri Mar 24 2000 - 18:13:22 CST