APEX

hi all,

i found out recently that i can use rowid as a parameter to pass when i want to fetch a row for editing in a form page. and normally when creating a report i use a view object of the corresponding table. of course the view will now have a row_id in it referencing the rowid column in the table.

so on the form, i created an item P1_ROWID, database column having ROWID as source. i also changed the primary key of my "Automated Row Fetch" (Fetch Row from MY_TABLE) to ROWID. it seems to work very well at the moment. but then i had an issue with the "Automatic Row Processing (DML)" (Process Row of MY_TABLE). in the process, i still have my primary key to the column instead of rowid but i guess since i have an item P1_ROWID, it seems that the process is including it on the DML transactions so then i get the error "ORA-06550: line 1, column 54: PL/SQL: ORA-01733: virtual column not allowed here ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored".

is there anyway around this error?

i do like having the fetch process to look at the rowid instead of the primary key id column (user_id for example) as this will prevent users from retrieving records using the URL by just changing the USER_ID to some other number.

thanks
allen