0
I Use This!
Activity Not Available

Project Summary

Logging record types in PL\SQLEver faced with the problem of logging a record in PL\SQL? Ever wondered why it's so hard to resolve this problem in a generic manner. This project is soly focused on this problem. The solution this project will provide is the ability to generate a package that can transform a record type into a string.

Just as a quick example :

declare
TYPE r_prsn IS RECORD
(id ra_relations.relt_id%TYPE
,reference ra_relations.relt_id%TYPE
,format_name ra_relations.relt_official_full_name%TYPE
,ind_alive ra_relations.relt_ind_alive__ntpr%TYPE
,name_clarification ra_relations.relt_name_clarification__ntpr%TYPE
,first_names ra_relations.relt_first_names__ntpr%TYPE
,infix ra_relations.relt_infix__ntpr%TYPE
,first_first_name ra_relations.relt_first_first_name__ntpr%TYPE
,call_name ra_relations.relt_call_name__ntpr%TYPE
,name_remarks ra_relations.relt_name_remarks__ntpr%TYPE
);

v_new r_person_type;
begin
v_new.id := '1';
v_new.call_name := 'Arnold Reuser';

dbms_output.put_line(v_new); // !!!! COMPILE TIME ERROR !!!
dbms_output.put_line(uno_log_pck.toString(v_new)); // !!! NO PROBLEM AT ALL !!!
end;The generated package uno_log_pck, used in the example stated above, transforms the record type r_person_type into a string. As a result dbms_output.put_line can log the runtime information of v_new. Therefore no more worries about logging a record in PL\SQL :)

Tags

No tags have been added

In a Nutshell, plgen...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Apache License 2.0
Permitted

Commercial Use

Modify

Distribute

Place Warranty

Sub-License

Private Use

Use Patent Claims

Forbidden

Hold Liable

Use Trademarks

Required

Include Copyright

State Changes

Include License

Include Notice

These details are provided for information only. No information here is legal advice and should not be used as such.

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    55% of companies leverage OSS for production infrastructure
  • ...
    you can embed statistics from Open Hub on your site
  • ...
    use of OSS increased in 65% of companies in 2016
  • ...
    search using multiple tags to find exactly what you need

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis