Hi all,
When I need information about the content in the attribute strings, I look in the debugger.
But where do I find the information, when the call does not show up in the debugger. Like this one?
archive_api.New_Client_Report()
Hi all,
When I need information about the content in the attribute strings, I look in the debugger.
But where do I find the information, when the call does not show up in the debugger. Like this one?
archive_api.New_Client_Report()
Have you used PL/SQL software? There you can browse all database objects and view documentation and code for each API and so on. It’s Oracle standard.
I could provide more information and examples if needed.
If your requirement is to check the attribute string values, when the call does not show in the debugger, you may have to add traces to the database level. For this, you can use TRACE_SYS.MESSAGE function and the output will be added to the trace tab of the debugger.
I recently had to use this:
archive_api.New_Client_Report(result_key_ OUT NUMBER,
report_attr_ IN VARCHAR2,
parameter_attr_ IN VARCHAR2,
distribution_list_ IN VARCHAR2,
print_attr_ IN VARCHAR2)
That seemed easy enough, except that I could not find any information about, e.g. report_attr_. I had to read the code to figure out that it most contain 'printer_id'.
Is there not any written documentation or function call I can do. Like:
get_attr_info('archive_api.New_Client_Report', 'report_attr_')
?
I know I have to use archive_api.New_Client_Report, but I do not have any attribute strings. It comes from this discussion.
I hope I made it clearer?
https://docs.ifs.com/techdocs/Foundation1/
After that in the search enter the relevant API. It will output the relevant methods and you can get an idea from there. See the screenshot below.
Hope this would do your job
I know I have to use archive_api.New_Client_Report, but I do not have any attribute strings. It comes from this discussion.
I hope I made it clearer?
As I aware there’s no such a method to get which values to put in attr and I’m so delighted if someone has an answer for that.
But as I see your main question is how to find attributes when the call is not visible in Debug Console.
Answer is, actually the call is there in the console but finding it is bit tricky since this scenario occurs when the call is a Server invoke instead of direct PLSQL.
Here’s how I find what parameters to add for Archive_api.New_Client_Report
Hope you find it useful.
Cheers!
Thanks... Someday, someone is going to get drunk.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.