sqlplus setting
DBA2011Sep 18 2006 — edited Sep 19 2006i want to execute some line which are long,
before pasting that to sqlplus which setting i should set for plsql ??
example after BEGIN all this is content in 2 line....
DECLARE
v_xml SYS.XMLTYPE;
v_doc CLOB;
BEGIN
v_doc := '<?xml version="1.0" encoding="utf-16"?><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:tns="http://www.siautomation.com/Maestria/schemas/Supervision"><xsl:output method="text" omit-xml-declaration="yes" /><xsl:template match="/">' || Chr(10) || '' || Chr(10) || '/* VARIABLES */' || Chr(10) || '' || Chr(10) || 'DECLARE' || Chr(10) || '' || Chr(10) || 'VAR_ExistingGroup NUMBER;' || Chr(10) || 'VAR_GroupID NUMBER;' || Chr(10) || '';
v_doc := v_doc || 'VAR_ExistingEquipment NUMBER;' || Chr(10) || 'VAR_EquipmentID NUMBER;' || Chr(10) || 'VAR_EquipmentGroupID NUMBER;' || Chr(10) || 'VAR_ExistingEventName NUMBER;' || Chr(10) || 'VAR_EventNameID NUMBER;' || Chr(10) || 'VAR_ExistingApplication NUMBER;' || Chr(10) || 'VAR_ApplicationID NUMBER;' || Chr(10) || 'VAR_ExistingMachine NUMBER;' || Chr(10) || 'VAR_MachineID NUMBER;' || Chr(10) || 'VAR_ExistingMaestriaUser NUMBER;' || Chr(10) || 'VAR_MaestriaUserID NUMBER;' || Chr(10) || '';