Recent content by azp74

Sorry - various combinations of closing PL/SQL Dev, restarting my machine, completely recreating my database etc etc appear to have fixed this problem. Alex

Hi I'm trying to test a stored procedure (which is called by another stored procedure). Having declared rpk in the declare block I then issue some SQL: select pk into rpk from sds.relationships_int where (mtr = pk and mtrversion = ver); pk and ver have been passed in to the stored...

After some rijigging I have successfully passed in a collection of both varchar2 and raw so there was obviously a bug in my PL/SQL which I was looking for far too hard! Sorry about that! Thanks Alex

Sorry - I see where the ambiguity lay in my original post - I gave 'ABC' and '123' as random examples of hex (rather than decimal or otherwise) strings ... the real values I'm using are actually guids which are getting passed in as (for example) '7E1C8CAE58C04194B7DF2C94A054EC31'. In addition...

We had a problem with NLS_LANG - make sure you don't also have to change the value of this in the registry ... you don't mention Oracle version or platform (assuming some flavour of windows) - our problem was with 10g on an XP sp2 box.

I have a stored procedure which takes two collections amongst its parameters. The first is a collection of raw(32) and the second a collection of ints (both of these are defined as types using varrays). In my test script both are declared & initialised in the same way: declare carray...

Thanks for the prompt response. Confusing is an understatement! Alex

I should have mentioned that I am running Oracle 9i 9.2.0.1.0 on a Windows XP sp2 box.

Hi I have an if/elsif statement nested inside another if statement: if condition then if v < ver then -- do something elsif v > ver then -- do something else end if; else -- some more stuff end if; v has been passed in to the stored procedure and ver has been set by a select into...