Search Source Code
get
/database/reports/data_dictionary/plsql/search_source_code/
For each PL/SQL object, lists the source code for each line, and allows the source to be searched for occurrences of the specified variable.
Request
Query Parameters
-
OBJECT_NAME(optional): string
PL/SQL Object Name
-
TEXT_STRING(optional): string
Text Search
-
limit(optional): integer(int32)
The maximum number of records to return.
-
offset(optional): integer(int32)
The index of the first record to start returning results for. Used with pagination.
Response
200 Response
The response returned by SQL Report Data endpoints will conform to this general pattern of paginated records. The actual structure of each item will vary depending on the report, the database version and the user's permissions.
Root Schema : ItemsCollection
Type:
Show Source
object
-
count(optional):
integer
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object ResourceItem
Additional Properties Allowed:
true