|
INTERVIEW QUESTIONS
PEOPLESOFT
PEOPLECODE
DETAILS
Question: What are the drawbacks of using a SQLExec built in function in PeopleCode?
Answer: Since the SQL statement is contained within quotes, it is a black box to PeopleSoft. Means the programmer is responsible for the syntax, efficiency and maintenance of the SQL. Also, if a SQLSelect is being performed within the function, only one row of data can be returned.
|
|
|
Category |
PeopleCode Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9251 users |
Added on |
9/17/2016 |
Views |
70610 |
Rate it! |
|
|
Question:
What are the drawbacks of using a SQLExec built in function in PeopleCode?
Answer:
Since the SQL statement is contained within quotes, it is a black box to PeopleSoft. Means the programmer is responsible for the syntax, efficiency and maintenance of the SQL. Also, if a SQLSelect is being performed within the function, only one row of data can be returned. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What Record Definitions will perform PeopleCode in a panel group?
|
View Answer
|
|
How do you turn off the PeopleCode trace?
|
View Answer
|
|
How do you turn on the PeopleCode Trace?
|
View Answer
|
|
How can you use WinMessage as part of the Debugging Process in PeopleCode?
|
View Answer
|
|
When is it useful to select the Export to File option in Find in PeopleCode?
|
View Answer
|
|
What does Find in PeopleCode do?
|
View Answer
|
|
Which two Cross Reference Reports are best for PeopleCode?
|
View Answer
|
|
How does AddToDate work in PeopleCode?
|
View Answer
|
|
What is the CurrentRowNumber in PeopleCode?
|
View Answer
|
|
Why is PriorValue used in PeopleCode?
|
View Answer
|
|
When should WinMessage be used in PeopleCode?
|
View Answer
|
|
How is a message retrieved from the Message Catalog in PeopleCode?
|
View Answer
|
|
How is a message added to the Message Catalog in PeopleCode?
|
View Answer
|
|
Why is the Message Catalog used in PeopleCode?
|
View Answer
|
|
Difference between MetaSQL and normal SQL in PeopleCode?
|
View Answer
|
|
What is PeopleCode Editor?
|
View Answer
|
|
Difference between Error and Warning functions in PeopleCode?
|
View Answer
|
|
Difference between CallAppEngine and CallSection functions in PeopleCode?
|
View Answer
|
|
Explain about Thin-time and Thick-time functions in PeopleCode?
|
View Answer
|
|
Explain about the WorkFlow Event in PeopleCode?
|
View Answer
|