Search results for query: *

Ok, Thanks everyone for your contributions

Hi Jim, Thanks again for the feedback. How about this scenario? I'm processing a list of employees using an explicit cursor and I'm updating the salary of the employees based on some criteria previously worked out. I want to capture the new salary of each employee updated using the following...

Hi, Thanks for the quick feedback however neither response seems to give me the answer I was hoping for. I don't need a workaround, rather I would like to know why I can't combine WHERE CURRENT OF and a RETURNING clause in the UPDATE statement. The example I have chosen is just a random...

Hi, Can anyone out there explain why I am unable to combine WHERE CURRENT OF and a RETURNING Clause in an UPDATE statement ( in an anonymous PL/SQL Block ). The following is an example of what I am trying to do: ... ... UPDATE orders SET order_date = order_date + 7 WHERE...

Hi, As I understand it, this file should be included in an Forms6i installation but for Forms 9i onwards you need to download it from OTN. Either way, you should be able to pick it up from OTN and use in either version regards, Bogman

Hi, I've been trying to INSERT a new row which includes a BFILE reference to an external BMP image file. The target column ( empimage ) for this image file is of type BLOB. I want to know if I can do this using an INSERT command rather than DBMS_LOB. A basic example of what I am trying and the...

Hi there, I have recently noticed that I am unable to combine the 'WHERE CURRENT OF ' and 'RETURNING .. INTO .. ' clauses in the same UPDATE statement ( when processing cursor rows in a PL/SQL block). It's not a big problem but I can't think of a logical reason why this is not allowed. A sample...

Hi, Thanks for your help. Sorry for taking so long to acknowledge it

The following command should do what you want as long as your account has the system privilege to drop another user: DROP USER username CASCADE

Hi, Something along the lines of the following code might be what you want: CREATE OR REPLACE PACKAGE my_pck IS TYPE my_ref_cursor_type IS REF CURSOR ; PROCEDURE get_records ( p_tab_in VARCHAR2, p_records OUT my_ref_cursor_type ) ; END my_pck ; / CREATE OR...

Hi, Within the same PLSQL block I am dynamically creating a table and then attempting to BULK insert records into it from an index by table called periods. However, the insert fails to compile and the error returned is ORA-0942 indicating that the table nmltrx_0304 does not exist.However, if I...

Dear all, I was wondering if it is possible to download a free copy of Personal Oracle 9i to run on Red Hat V9. I have searched the OTN site but couldn't find anything that helped. Does anyone out there know anything? regards, KEvin.

Hi, I was wondering if anyone out there has been successful in implementing menu security on Forms. I have tried and failed to get this feature to work for me. I have carried out the following steps to get it to work: On the database: CREATE ROLE trainers ; GRANT CONNECT, RESOURCE TO...