1
<html xmlns="http://www.w3.org/1999/xhtml">
3
<script src="../../js/codemirror.js" type="text/javascript"></script>
4
<title>CodeMirror: PLSQL demonstration</title>
5
<link rel="stylesheet" type="text/css" href="../../css/docs.css"/>
7
<body style="padding: 20px;">
9
<p>Demonstration of <a href="index.html">CodeMirror</a>'s PLSQL
12
<p>Written by Peter Raganitsch (<a href="LICENSE">license</a>), based
13
on John Benediktsson <a href="../sql/index.html">SQL parser</a>.</p>
16
<textarea id="code" cols="120" rows="50">
17
PROCEDURE generateResult
18
( pRoutineType IN VARCHAR2
19
, pReferenceType IN VARCHAR2
20
, pReferenceId IN NUMBER
23
ROUTINE_NAME CONSTANT VARCHAR2(30) := 'generateResult';
25
vDisplayAs APEXLIB_V_PAGE_ITEM.DISPLAY_AS %TYPE;
26
vLovQuery APEXLIB_V_PAGE_ITEM.LOV_QUERY %TYPE;
27
vDisplayNullValue APEXLIB_V_PAGE_ITEM.LOV_DISPLAY_NULL%TYPE;
28
vLovNullText APEXLIB_V_PAGE_ITEM.LOV_NULL_TEXT %TYPE;
29
vLovNullValue APEXLIB_V_PAGE_ITEM.LOV_NULL_VALUE %TYPE;
30
vApplicationId APEXLIB_V_PAGE_ITEM.APPLICATION_ID %TYPE;
31
vPageId APEXLIB_V_PAGE_ITEM.PAGE_ID %TYPE;
33
----------------------------------------------------------------------------
34
-- Determine which routine to call and pass parameters
35
----------------------------------------------------------------------------
39
ApexLib_Lov.generateLovResult( pReferenceType, pReferenceId );
43
ApexLib_Computation.generateComputationResult( pReferenceType, pReferenceId );
46
Apexlib_Error.raiseImplError('Unsupported routine type "'||pRoutineType||'"!');
49
EXCEPTION WHEN OTHERS THEN
50
HTP.prn('Error: '||SQLERRM);
51
-- RAISE; no raise, because APEX doesn't care anyway.
56
<script type="text/javascript">
57
var editor = CodeMirror.fromTextArea('code', {
59
parserfile: "../contrib/plsql/js/parseplsql.js",
60
stylesheet: "css/plsqlcolors.css",