imported>Runabout5921: Added short description

2025-03-07T21:10:36Z

Added short description

New page

{{Short description|Proprietary programming language}}
{{multiple issues|
{{More citations needed|date=April 2014}}
{{notability|date=January 2014}}
}}

{{Infobox programming language
| name = PeopleCode
| paradigm = [[Multi-paradigm programming language|multi-paradigm]]: [[Object-oriented programming|object-oriented]], [[Imperative programming|imperative]]
| developer = [[Oracle Corporation]]
}}
'''PeopleCode''' is a proprietary [[object-oriented language|object-oriented]] programming language used to express [[business logic]] for [[PeopleSoft]] applications. Syntactically, PeopleCode is similar to other programming languages, and can be found in both loosely-typed and strongly-typed forms. PeopleCode and its run-time environment is part of the larger [[PeopleTools]] framework. PeopleCode has evolved over time and its implementation through the PeopleSoft applications lack consistency. PeopleCode offers some interoperability with the Java programming language. Definition name references, for example, enable you to refer to PeopleTools definitions, such as record definitions or pages, without using hard-coded [[string literal]]s.<ref>DeLia, Tony et al. (2001). ''Essential Guide to Peoplesoft Development and Customization.'' ''Manning Publications Co.'' p.260</ref> Other language features, such as PeopleCode [[data type]]s and [[metastring]]s, reflect the close interaction of PeopleTools and [[Structured Query Language]] (SQL). [[Object-oriented programming|Dot notation]], [[Class (computer science)|classes]] and [[Method (computer science)|methods]] in PeopleCode are similar to other object oriented languages, like [[Java (programming language)|Java]]. Object syntax was an important feature of PeopleTools 8.<ref>DeLia, Tony et al. (2001). ''Essential Guide to Peoplesoft Development and Customization.'' ''Manning Publications Co.'' p.417</ref>

{{TOClimit|limit=3}}

==Language features==

===Supported functions===

PeopleCode supports the following types of functions:<ref>DeLia, Tony et al (2001). ''Essential Guide to Peoplesoft Development and Customization.'' p.375</ref>
* Built-in: The standard set of PeopleCode functions. These can be called without being declared.
* Internal: Functions that are defined (using the Function statement) within the PeopleCode program in which they are called.
* External PeopleCode: PeopleCode functions defined outside the calling program. These are generally contained in record definitions that serve as function libraries.
* External non-PeopleCode: Functions stored in external (C-callable) libraries.

In addition, PeopleCode supports methods. The main differences between a built-in function and a method are:
* A built-in function is on a line by itself, and does not (generally) have any dependencies.
* A function can be used before instantiating the object.
* A method can only be executed by an object (using dot notation).
* The object must be instantiated first.

===Describing Application Class Structure===

* Import any classes that will be used by a class, including the superclass this class extends

<pre>
Import PackageName:Superclassname;
</pre>

* A class is defined using the Class construct.

<pre>
Class Classname [Extends SuperClassname]
[Method_declarations]
[Property_declarations]
[Private
[Method_declaration]
[Instance_decalarion]
[[Constant declaration]]
End-class;
</pre>

* The first set of declarations are the properties and methods that are part of the public, external interface.

<pre>
Property datatype PropertyName [get][set];
Method MethodName ([parameter_list])
</pre>

* The private instance variables, constants, and the methods are declared following the keyword <code>Private</code>.

{{pre|<nowiki/>
Private
Instance DataType {{not a typo|&InstanceName;}}
Constant &Constant {{=}} {Number {{!}} String {{!}} True {{!}} False {{!}} Null };
}}

* The keyword <code>end-class</code> follows the declarations of properties, methods, instances, and constants.
* After the <code>end-class</code> keyword and before <code>get</code> and <code>set</code> definitions or method definitions, declare any variable and functions that will be used by methods.
* Get and set methods corresponds to properties declared with the get and set keywords.
* Use a <code>get</code> method definition to execute PeopleCode that will return a value.

{{pre|<nowiki/>
get Propertyname
Return {{not a typo|&Value;}}
end-get;
}}

* Use a <code>set</code> method definition to execute PeopleCode that will change a value.

<pre>
set PropertyName

end-set;
</pre>

* Method definitions are similar to function definitions.

<pre>
method Methodname
statements;
end-method;
</pre>

* A special case of a method definition is the <code>constructor</code>.
* A constructor has the same name as the class and will always run when the class is instantiated.
* A class that does not extend some other class does not need any constructor.
* A class that does extend another class must have a constructor, and in the constructor, it must initialize its superclass.

===Executing SQL in PeopleCode===

* Where a <code>SQLExec</code>(built-in function) only delivers a single row, using the <code>SQL</code> class you can retrieve and process multiple rows.
* Instantiate a SQL object with the <code>CreateSQL</code> built-in function.
** Use <code>CreateSQL("SQLString")</code> to pass a text string to your SQL object.
** Use <code>GetSQL(SQL.sqlname)</code> to get the SQL from a SQL definition.

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

<pre>
&SQL = CreateSQL("SQL Statement");
&SQL.Execute([bind_values]);
</pre>

* For a SQL object containing a Select statement, the <code>Fetch</code> method is used to retrieve the next row from the cursor.

{{Citation
| title = PeopleCode Functions
| url=http://www.homemarketeer.com/peoplecode/peoplecode.htm
| accessdate = 2008-12-14 }}

== See also ==
*[[PeopleSoft]]
*[[PeopleTools]]

== External links ==
*For further documentation on PeopleCode
* http://download.oracle.com/docs/cd/E05317_01/psft/html/docset.html (Version 8.49)
* http://download-east.oracle.com/docs/cd/B31274_01/psft/html/docset.html{{dead link|date=March 2018 |bot=InternetArchiveBot |fix-attempted=yes }} (Version 8.48)

== References ==
{{reflist}}

[[Category:Oracle software]]

PeopleCode - Revision history

imported>Runabout5921: Added short description