I'm still at a loss as to why, inside a Test Window, cut/paste a string into my CLOB parameter doesn't work, but here's my work-around for anyone interested.

The theory is since this is development, store my long string(XML) in a table then select it out from with my Test Window. The actual procedure is called from Cold Fusion, so going through these steps are unnecessary for them.

So...

a) Create table and populate with CLOB data:
CREATE TABLE test_clob (
a INTEGER,
a_clob CLOB)
TABLESPACE data_128k;

INSERT INTO test_clob VALUES (
1, '<long string of XML here>');

COMMIT;

b) Startup a new Test Window. In the bottom pane, uncheck the parameter that is a CLOB to avoid ORA-01036 error.

c) Modify the test script to read:

DECLARE
v_clob CLOB;
--
CURSOR get_clob IS
SELECT a_clob
FROM test_clob
WHERE a = 1;
BEGIN
OPEN get_clob;
FETCH get_clob INTO v_clob;
CLOSE get_clob;

-- Call the procedure
emp_mgr.saveemp(p_token => :p_token,
p_empXML => v_clob);
end;

Now I can step through the custom XML/tag parsing routines to see what is going in.

- Tim