PeopleCode

<h2 id="language-features">Language features</h2>
<h3>Supported functions</h3>
<p>PeopleCode supports the following types of functions:<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a>
</p>
<ul><li>Built-in: The standard set of PeopleCode functions. These can be called without being declared.</li>
<li>Internal: Functions that are defined (using the Function statement) within the PeopleCode program in which they are called.</li>
<li>External PeopleCode: PeopleCode functions defined outside the calling program. These are generally contained in record definitions that serve as function libraries.</li>
<li>External non-PeopleCode: Functions stored in external (C-callable) libraries.</li></ul>
<p>In addition, PeopleCode supports methods. The main differences between a built-in function and a method are:
</p>
<ul><li>A built-in function is on a line by itself, and does not (generally) have any dependencies.</li>
<li>A function can be used before instantiating the object.</li>
<li>A method can only be executed by an object (using dot notation).</li>
<li>The object must be instantiated first.</li></ul>
<h3>Describing Application Class Structure</h3>
<ul><li>Import any classes that will be used by a class, including the superclass this class extends</li></ul>
   Import PackageName:Superclassname;

<ul><li>A class is defined using the Class construct.</li></ul>
    Class Classname [Extends SuperClassname]
         [Method_declarations]
         [Property_declarations]
    [Private
         [Method_declaration]
         [Instance_decalarion]
         [[Constant declaration]]
     End-class;

<ul><li>The first set of declarations are the properties and methods that are part of the public, external interface.</li></ul>
   Property datatype PropertyName [get][set];
   Method MethodName ([parameter_list])

<ul><li>The private instance variables, constants, and the methods are declared following the keyword Private.</li></ul>
   Private
     Instance DataType &InstanceName;
     Constant &Constant = {Number | String | True | False | Null };
<ul><li>The keyword end-class follows the declarations of properties, methods, instances, and constants.</li>
<li>After the end-class keyword and before get and set definitions or method definitions, declare any variable and functions that will be used by methods.</li>
<li>Get and set methods corresponds to properties declared with the get and set keywords.</li>
<li>Use a get method definition to execute PeopleCode that will return a value.</li></ul>
   get Propertyname
    Return &Value;
   end-get;
<ul><li>Use a set method definition to execute PeopleCode that will change a value.</li></ul>
   set PropertyName
    
   end-set;

<ul><li>Method definitions are similar to function definitions.</li></ul>
   method Methodname
    statements;
   end-method;

<ul><li>A special case of a method definition is the constructor.</li>
<li>A constructor has the same name as the class and will always run when the class is instantiated.</li>
<li>A class that does not extend some other class does not need any constructor.</li>
<li>A class that does extend another class must have a constructor, and in the constructor, it must initialize its superclass.</li></ul>
<h3>Executing SQL in PeopleCode</h3>
<ul><li>Where a SQLExec(built-in function) only delivers a single row, using the SQL class you can retrieve and process multiple rows.</li>
<li>Instantiate a SQL object with the CreateSQL built-in function.
<ul><li>Use CreateSQL("SQLString") to pass a text string to your SQL object.</li>
<li>Use GetSQL(SQL.sqlname) to get the SQL from a SQL definition.</li></ul></li></ul>
   &SQL = CreateSQL("SQL Statement",[bind values]);

<p>The values for the bind variables can be omitted and supplied later.  For Insert, Update, or Delete commands these values would be supplied using Execute method.
<i>(If all the necessary input values are supplied, the SQL is executed immediately.)</i>
</p>
    &SQL = CreateSQL("SQL Statement");
    &SQL.Execute([bind_values]);

<ul><li>For a SQL object containing a Select statement, the Fetch method is used to retrieve the next row from the cursor.</li></ul>
<p><a href="http://www.homemarketeer.com/peoplecode/peoplecode.htm"><i>PeopleCode Functions</i></a>, retrieved 2008-12-14
</p>
<h2 id="see-also">See also</h2>
<ul><li><a href="/facts/PeopleSoft/qMMqP2jJ">PeopleSoft</a></li>
<li><a href="/facts/PeopleTools/99JVy4hV">PeopleTools</a></li></ul>
<h2 id="external-links">External links</h2>
<ul><li>For further documentation on PeopleCode</li>
<li><a href="http://download.oracle.com/docs/cd/E05317_01/psft/html/docset.html">http://download.oracle.com/docs/cd/E05317_01/psft/html/docset.html</a> (Version 8.49)</li>
<li><a href="http://download-east.oracle.com/docs/cd/B31274_01/psft/html/docset.html">http://download-east.oracle.com/docs/cd/B31274_01/psft/html/docset.html</a>[<i>permanent dead link</i>] (Version 8.48)</li></ul>

<h2 id="references">References</h2>

<ol>
<li id="fn:1"><p>DeLia, Tony et al.  (2001). Essential Guide to Peoplesoft Development and Customization. Manning Publications Co. p.260 <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li>
<li id="fn:2"><p>DeLia, Tony et al.  (2001). Essential Guide to Peoplesoft Development and Customization. Manning Publications Co. p.417 <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li>
<li id="fn:3"><p>DeLia, Tony et al  (2001). Essential Guide to Peoplesoft Development and Customization. p.375 <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li>
</ol>

PeopleCode open-in-new

PeopleCode