Need Help - Oracle Designer API
Date: 23 Apr 2002 07:53:28 -0700
Message-ID: <82d2b910.0204230653.500f313e_at_posting.google.com>
I was just wondering if anyone had any good up to date documentation on Oracle Designer 6i's API. I am having a really hard time finding any good current info on how the API works for Designer 6i. I have read through the API help, but there is only one example and it doesn't cover the Multi Line Text. Oracle has changed many of the aspects of how it works now. The SDD tables don't exist in the current version and many of the API calls have change. I understand that there was a book written called Oracle Designer Handbook, but I am not sure if it contains the latest info.
Basically what I am trying to do is figure out how to update and change the RM_Text_Lines table using the API calls. This table is where the notes and descriptions are now kept at least according to the Oracle API help documentation. It used to be stored in the CDI_Text table. It seems info is stilled stored there, but now also resides in the RM_Text_Lines table as well.
I wrote some code to do this but the API calls using the RMOTEXTP functions don't seem to do anything. The RMOTEXTP API calls are supposed to deal with the multiline Notes and Description Fields. These values are now contained in a table called RM_Text_Lines. I don't receive an error for the 3 calls I make in the SQL code below, but when I try to display the results using dbms_output.put_line , nothing shows up.
Below is a sample of my code. The RMOTEXTP.Writeall command does seemed to have bugs. I get errors saying the record could not be updated due to fields which require values other than what the function passes. Basically the RM_Text_Lines file contains fields which require Non Null values and the RMOTEXTP.Writeall API call seems to be updating these fields with Nulls.
Thanks
You can email me at tcrandall_at_pec.com
set serveroutput on
exec dbms_output.enable(60000);
DECLARE
ent cioentity.data; -- Property list for ENTITY
act_status VARCHAR2 (1); -- Activity status
act_warnings VARCHAR2 (1); -- Activity warning flag
v_buflen integer;
v_buffer varchar2 (10);
v_bufret varchar2 (10);
BEGIN
- Set the context workarea
jr_context.set_workarea('repuser_workarea');
-- Initialize API if not already done
if cdapi.initialized = FALSE then- Initialize the API global items
cdapi.initialize (upper ('BATS3'));
end if;
- Open a new activity dbms_output.put_line ('Opening a new activity'); cdapi.open_activity; rmotextp.lengthall (826792288550257497646693207022525460, 'CDINOT', v_buflen); rmotextp.readall (826792288550252775280210337377311764,'CDINOT',v_buffer, 10, v_bufret); rmotextp.truncall (826792288550252775280210337377311764,'CDINOT'); dbms_output.put_line (v_buflen); dbms_output.put_line (v_buffer); dbms_output.put_line (v_bufret);
- Attempt to close the activity cdapi.close_activity (act_status); if act_status != 'Y' then cdapi.abort_activity; dbms_output.put_line ('Activity aborted with ORACLE internal errors'); else dbms_output.put_line ('Close Activity'); end if; END; /
- Initialize the API global items
cdapi.initialize (upper ('BATS3'));
end if;