Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    That's what I was afraid of. Looks like I'll have to find a less elegant solution to this problem. Thanks!
  2. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Ok. Follow-up on this. I found the problem with selecting from the temp table. I'd been attempting to do open p_cursor for select * from ipts_sd.corr_item_temp; When I should have been doing: open p_cursor for 'select * from ipts_sd.corr_item_temp'; The single quotes make it so that...
  3. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Well, that's the trick with this one. I need the temp tables to be different for every letter that is generated. So, I need a system where there can be multiple users with their own version of the temp table that will have different columns (and number of columns). Really, all I want is a local...
  4. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Well, that works just fine. Thanks! I'll have to play with it to see why my code isn't working properly. Anyone have any ideas on what I'm doing wrong?
  5. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Well, it may be possible to do it that way, I just don't know what the SQL would be for combining x number of records into a single record without a holding space of some sort. I need to be able to take some number of records (between 2 and 100) and recombine them into a single record with...
  6. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Somewhere around 100.
  7. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    Making the table transactional or just session based doesn't bother me. It'll get dropped eventually anyway, and I've got logic in to drop it if it exists anyway. I'll try to be a little more specific. The table that holds the letters looks like this Letter_ID Letter_Item_Label...
  8. Mephansteras

    Create a temp table within a procedure and return a ref cursor

    I need to do something that seems like it'd be easy, but I can't for the life of me figure out how to do this in oracle. We have a table that contains information about letters that contains (among others) the fields: Letter Id, Column_Nm and Column_Val. A given letter might have anywhere from...
  9. Mephansteras

    Finding data on Excel

    You may want to try using the Spreadsheet::ParseExcel module from CPAN. It is specifically designed for dealing with excel, and I have always found it very easy to use.
  10. Mephansteras

    Help creating a CSV file

    You have a LOT of options. How big are your files going to be? If you are just trying to lots of small files that contain a single record, as it were, I would probably just read in each file one at a time (pass the program a list of files to read). Then, for each line, do a split on '='. Take...
  11. Mephansteras

    MVS::JESFTP question

    Well, the test script that comes with the MVS::JESFTP package does that, so I sort of assume it is possible. I'll check out that website. Thanks!
  12. Mephansteras

    MVS::JESFTP question

    That looks like it worked. I guess I need to just send in the JCL I want rather than calling the JCL that is already on the mainframe. Eh. Whatever works. Thanks chazoid!
  13. Mephansteras

    File&Record Handling

    Well, first thing I see is that the variable $output_file is not being set anywhere. You are trying to output to a null location.
  14. Mephansteras

    MVS::JESFTP question

    I'm really not sure if this is more a mainframe question or an issue with the perl package. But I'm stuck either way. We have a job that gets run manually on the mainframe, and a perl job on a linux box that runs a little later and grabs the file off of the mainframe that is produced by the...
  15. Mephansteras

    Problem defining a string

    Another way to deal with variables in the middle of a word is to to do something like this: src='${server}${celebid}1024x768.jpg'> which will let perl know what the variable names you are using are.
  16. Mephansteras

    mldbm save?

    Your problem is that MLDBM does not support the standard multi-level perl hash structure. You have to create a temporary hash with the multi-level structure and then set the top level into your tied hash. Something like this: my %temp_users; $temp_users{$temp{$fh}}{'user'} = $temp{$fh}...
  17. Mephansteras

    date manipulation

    Date::Manip will do just about anything. It's not fast, though, so if you need speed you'd be better off using one of the other packages on CPAN. Date::Calc, for instance, is quite a bit faster for most applications. If you don't need speed, however, I've found that Date::Manip is great to have...
  18. Mephansteras

    learning perl

    The books mentioned in that thread are really good, as is the Perl Black Book, which I find indespensible for actually solving problems. It is geared towards people who have a job to do and need a solution now, not tomorrow. ;)
  19. Mephansteras

    ow to determine a multidimensional array's size? hash size?

    While I don't know of any automatic ways to determine the length of a hash, you could write a quite subroutine to do so. my $hashcount = &GetHashCount(\%myHash); sub GetHashCount { my $hash_ref = shift; my $count = 0; foreach $key (keys $%hash_ref) { $count++...
  20. Mephansteras

    dimensional arrays

    If using 'my' on some of the variables fixed it, you probably had a locality problem. Were $horz and $vert populated somewhere else in the script before you tried to use them? Without seeing the whole script, my guess would be that something somewhere else was changing the values of $horz and...

Part and Inventory Search

Back
Top