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 derfloh 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: *

  • Users: Petemush
  • Order by date
  1. Petemush

    Literal Escape Character?

    I did have that as an option, just thought it might be a bit overkill to create an array(of sorts) for something so simple. jaggiebunnet: Yes, I was trying to append the loop variable to the variable name and then look at the result as if it was a variable. Cheers for the suggestion about...
  2. Petemush

    Literal Escape Character?

    Yeah, the variables have already been defined. Basically they're each a running total from a FOR loop that happened before this LOOP so when you get to this point, some of them will have a value of 0 and others will have a value greater than 0. CREATE OR REPLACE PROCEDURE HSP_EXT_DIDOS_PO IS...
  3. Petemush

    Literal Escape Character?

    Bugger! Cheers for letting me know Dima, don't really know how to utilise your alternative suggestions with what I want to do though. I've basically got 7 variables(variable1 to variable7) and I want to do a similar thing to each but need to check that the value of the variable is greater than...
  4. Petemush

    Literal Escape Character?

    Hi, I'm trying to find out whether PLSQL has an escape character to indicate that the text following it should be taken as a literal. To explain: I want to use the following statement: DECLARE variable1 VARCHAR2 := 'a value' BEGIN IF variable || '1' = 'a value' THEN The way this reads...
  5. Petemush

    PLS-00306 Error for Sub Function

    Cheers for that Dima, I got an answer off MetaLink earlier on which went into detail on the whole scope thing with the SQL Engine for the cursor etc. etc. and have now managed to test it with a dummy procedure trying to reference a local variable from a cursor and it failing. Also worked out...
  6. Petemush

    PLS-00306 Error for Sub Function

    Cheers for all this Dima, I did a search through hsp_ext_didos_corp and found no other hsp_supp_type functions or otherwise. Pretty sure there is no hsp_ext_didos_corp user but had a search through the users table and came up with nowt. What suggests most to me that the line in the cursor is...
  7. Petemush

    PLS-00306 Error for Sub Function

    Right, Oracle is 8.1.7.4.0, just noticed that I posted this in the 9i forum so if anyone has the power, would be good if it could be moved, sorry about that! I noticed I used the phrase "main program" in my original post, what I meant by that was the main procedure. This function is defined...
  8. Petemush

    PLS-00306 Error for Sub Function

    Cheers Dima, I've already looked for that possibility and couldn't find any other functions called hsf_supp_type. Also tried doing a Describe and nothing happened. I know that my procedure is looking at my "private" function because if I comment the function out then I get an "hsf_supp_type...
  9. Petemush

    Tailing everything but the first line

    Thanks everyone for that, and there was me thinking there wasn't even one way!
  10. Petemush

    PLS-00306 Error for Sub Function

    Hello, I have an interesting twist on the ever loved PLS-00306 wrong number or types of arguments in call to ... error! I have a stored procedure which amongst other things, has a function defined inside of it. Cut down version is like so: CREATE OR REPLACE PROCEDURE hsp_ext_didos_corp (...
  11. Petemush

    Tailing everything but the first line

    Hello again! Does anyone know how to return an entire file apart from the first line? Like using tail? So I have a file: 1233 125457 123214235 213123 and I want the following returned: 125457 123214235 213123 Cheers,
  12. Petemush

    Return first occurrence of GREP only

    I've just noticed that the option -m might be what I'm after but I don't seem to have it with my version of grep. Bugger!
  13. Petemush

    Return first occurrence of GREP only

    I'm pretty sure there isn't an option on grep but can anyone think of a way to only return the first matching line that grep finds? Cheers
  14. Petemush

    Using a PL/SQL table column as an IN OUT Parameter?

    Hello, I have a procedure with a number of formal parameters where the actual parameters I pass in are PL/SQL table columns. I wanted to know, if I make some of the formal parameters IN OUT parameters, will the PL/SQL table columns get updated when the formal parameters are changed within the...
  15. Petemush

    WHEN-REMOVE-RECORD -> Loop thru block and update.

    Sorry, what I meant was that in the record group, I was recording the row id whenever you insert a row with certain data. Like you say, since the row id's change, this isn't a viable way of doing it. I've pretty much done what you've suggested and started recording the data and matching against...
  16. Petemush

    WHEN-REMOVE-RECORD -> Loop thru block and update.

    Hi Lewis, Thanks for that, it does seem to be the way forward. The problem now is that if you delete a row from the block, any rows with a greater TRIGGER_RECORD than the row just deleted, have their TRIGGER_RECORDS decreased by one. So if there were two rows that I had recorded in the record...
  17. Petemush

    WHEN-REMOVE-RECORD -> Loop thru block and update.

    Hi, I'm using Oracle Forms 6i. I have a form with 3 blocks on it. Like so: _____________ | BLOCK 1 | |_____________| |BLOCK2|BLOCK3| |______|______| In block 3 I have a text item which repeats down indefinitely with a scrollbar to the right. Whenever I insert a new row into...
  18. Petemush

    Default Value in ACCEPT ... PROMPT?

    Hi, Using the syntax ACCCEPT variableName PROMPT 'How many of whatever would you like?: ' Is it possible for a default value to be displayed so the user can just press return to accept it? So the prompt would look like: How many of whatever would you like?: DefaultValueHere Cheers, Pete
  19. Petemush

    Dreamweaver Opens Help Files

    I think it's going to be a re-install cos the htm, html file types etc are definitely associated with the browser that I use so no clues there! Cheers for your help
  20. Petemush

    Dreamweaver Opens Help Files

    Hello, Having recently installed Dreamweaver MX on a friends computer, now when they press F1 in Adobe Photoshop, Dreamweaver attempts to load the help files. This happened in a couple of other programs as well, Dreamweaver tried to open the help files. I had a look at file types and CHM and...

Part and Inventory Search

Back
Top