Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Unanswered: store procedure help needed

    hi,
    my program generates a new table every day with suffix(ddmy) format when ever any error generates during inserting into database.ex:tmpvam2583.each table may contain diff error codes.i am interested in looking the errors with out parsing them and generate a report.

    what i need is clubbing theses 2 queries

    select table_name from all_tables where table_name like 'tmpvam%'


    and


    select distinct error_code from <table_name>

    if there are 100 tables then report should look like

    tmpvam2473 2,4,5
    tmpvam2583 4
    .
    .
    .
    .
    .
    tmpvam2214 1,2,3

    like this

    can any one help me

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: store procedure help needed

    Originally posted by popurivamsi
    hi,
    my program generates a new table every day with suffix(ddmy) format when ever any error generates during inserting into database.ex:tmpvam2583.each table may contain diff error codes.i am interested in looking the errors with out parsing them and generate a report.

    what i need is clubbing theses 2 queries

    select table_name from all_tables where table_name like 'tmpvam%'


    and


    select distinct error_code from <table_name>

    if there are 100 tables then report should look like

    tmpvam2473 2,4,5
    tmpvam2583 4
    .
    .
    .
    .
    .
    tmpvam2214 1,2,3

    like this

    can any one help me
    Wouldn't it make more sense to have one error table, with a column for the date? Makes your reporting trivial then, doesn't it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •