Hi Quentin,
I see this issue executing via the conductor isql UI but it does not occur
when run against the command line isql
SQL> create procedure test.test.testUserDrop ( )
test.test.testUserDrop(0) {
test.test.testUserDrop(1) DB.DBA.USER_CREATE('testUser','badpassword');
test.test.testUserDrop(1) };
Done. -- 1 msec.
SQL> test.test.testUserDrop();
Done. -- 2 msec.
SQL> user_drop('testUser');
Done. -- 2 msec.
SQL>
Will ask development to check why the might be occurring via the Conductor ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 20 Feb 2014, at 12:39, Quentin <quent...@clearbluewater.com.au> wrote:
> Two interesting but ultimately trivial errors.
>
> The documentation merely has USER_CREATE() but this will error if the schema
> context is not DB.DBA. A trivial enough issue.
>
> create procedure test.test.testUserDrop ( )
> {
> DB.DBA.USER_CREATE('testUser','badpassword');
> };
> test.test.testUserDrop();
> user_drop('testUser');
>
> The statement execution did not return a result set.
> SQLState: 42000
> Message: U0002: The object "testUser" does not exist.
>
> user_drop('testUser')
>
>
> This is more trivial than it looks. The user really was deleted but an
> exception was thrown anyway. The effect is more annoying than serious though
> if the user_drop is done from a function, it would cause that function to
> exit prematurely which could be serious.
>
> Interestingly, this code works without error:
> user_create('testUser','badpassword);
> user_drop('testUser');
>
> The debug log doesn't offer any clues.
>
> Version 7.1.1-dev.3207-pthreads as of Feb 17 2014
> Compiled for Linux (x86_64-unknown-linux-gnu)
>
>
> --
> Quentin | Clear Blue Water Pty Ltd
> quent...@clearbluewater.com.au
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
