Tag Info

Hot answers tagged

2

This could be done this way. I don't like it much as it is not very elegant and looks fragile if unexpected things happen. --1)Create a table in the user's schema or another new schema if you want separation. CREATE TABLE DATA_AUDIT ( Primary_key RAW(16) default SYS_GUID() not null, Data_id Number(10), Action VARCHAR2(10), Date_created ...


2

I did a little bit more research and found the answer to the problem. Even though the first parameter for DBMS_OUTPUT.PUT_LINE is listed as item in the 10g documentation for DBMS_OUTPUT. The actual name for the parameter is A. You need to bind the name using DBMS_OUTPUT.PUT_LINE(A => 'random text'). The actual parameter names for stored procedures can ...



Only top voted, non community-wiki answers of a minimum length are eligible