Home » Other » Marketplace » Pl/Sql, Pro*C Process Code Generator For Oracle (SnapProc)
Pl/Sql, Pro*C Process Code Generator For Oracle [message #553757] Tue, 08 May 2012 06:15 Go to next message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
Create Multi Table Source Code in Minutes, without Programming
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #553759 is a reply to message #553757] Tue, 08 May 2012 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it!

Regards
Michel
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554339 is a reply to message #553759] Sun, 13 May 2012 01:50 Go to previous messageGo to next message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
Dunnit!

SnapProc Pl/Sql, Pro*C Process Code Generator For Oracle

Regards.

[Updated on: Sun, 13 May 2012 01:54]

Report message to a moderator

Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554340 is a reply to message #554339] Sun, 13 May 2012 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So post the result now. Wink

Regards
Michel
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554377 is a reply to message #554340] Mon, 14 May 2012 00:59 Go to previous messageGo to next message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
Sample code generated by SnapProc is shown below:

Code is right here


[EDITED by LF: applied [spoiler] tags to shorten a message. Supertime2000, have a look here to learn how to use [code] tags which will preserve formatting. This time, I did that for you.]

[Updated on: Mon, 14 May 2012 01:10] by Moderator

Report message to a moderator

Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554407 is a reply to message #554377] Mon, 14 May 2012 04:15 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
What on earth is this supposed to be doing:
procedure spsumup_ft3 is
BEGIN
        if upord_cursor%isopen = false then
                OPEN upord_cursor ;
        else
                CLOSE upord_cursor ;
                OPEN upord_cursor ;
        end if;
        UPDATE spupord
        SET spupord.saltax = salestax, spupord.subtot = subtotal
        WHERE rowid = pupord_row ;
    return ;
END spsumup_ft3 ;


You open a global cursor and do nothing with it, then do an unrelated update using global parameters.

The code just generally looks badly constructed.
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554412 is a reply to message #554407] Mon, 14 May 2012 04:50 Go to previous messageGo to next message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
True. It should read:

procedure spsumup_ft3 is
BEGIN
if spupord_cursor%isopen = false then
OPEN spupord_cursor ;
else
CLOSE spupord_cursor ;
OPEN spupord_cursor ;
end if;
UPDATE spupord
SET spupord.saltax = salestax, spupord.subtot = subtotal
WHERE rowid = spupord_row ;
return ;
END spsumup_ft3 ;

We appreciate. Pardon the aberration. How about visiting SnapProc site and telling us how you like the 'concept' of generating all this code without actually programming? Thank u.
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554438 is a reply to message #554412] Mon, 14 May 2012 08:43 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
supertime2000 wrote on Mon, 14 May 2012 10:50
True. It should read:

procedure spsumup_ft3 is
BEGIN
if spupord_cursor%isopen = false then
OPEN spupord_cursor ;
else
CLOSE spupord_cursor ;
OPEN spupord_cursor ;
end if;
UPDATE spupord
SET spupord.saltax = salestax, spupord.subtot = subtotal
WHERE rowid = spupord_row ;
return ;
END spsumup_ft3 ;

We appreciate. Pardon the aberration. How about visiting SnapProc site and telling us how you like the 'concept' of generating all this code without actually programming? Thank u.


The only difference between that and what I quoted is the cursor name. It still makes no sense what so ever.
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554441 is a reply to message #554438] Mon, 14 May 2012 08:59 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
And then there's this:
        while TRUE loop

That's your idea of professional code? An infinite loop?
OK - I know there are exit statements, but seriously, why set up the risk of an infinite loop in the first place?

Your autogenerated code would not pass code review at any professional site.
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #554496 is a reply to message #554441] Mon, 14 May 2012 22:42 Go to previous messageGo to next message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
This code generation interface was written in the 90s on DOS and then in 2002, it was migrated to Windows. And now, the code generation is on the Net. It requires no presence of Oracle to work. And in fact, it has been developed without using Oracle directly. It's not about aberrations in code, it is about the idea, the concept. Look at the inteface, not just the code. Only some community support can put the code in order. And it all begins with words of encouragement for an innovative idea. Programming is not about doing difficult things, it is about simplifying them. The developer kept this unique idea alive for two decades in all adversity, changing platforms. But Oracle Corporation and the Community failed to take notice and move it forward. And sadly, as we can see, the scene still remains skeptical. Our question: Does Oracle or any third party, have anything for a common man to create multi table pl/sql, pro*c code? All the best!
Re: Pl/Sql, Pro*C Process Code Generator For Oracle [message #612346 is a reply to message #554340] Wed, 16 April 2014 06:36 Go to previous message
supertime2000
Messages: 6
Registered: May 2012
Junior Member
Yahoo! Try this Googley - 'Online, Multi Table, PL/SQL, Pro*C, Process, Source, Code, Generator, Oracle, Create, Programming, Free' - bingO!
Previous Topic: Business Intelligence
Next Topic: Oracle Developer
Goto Forum:
  


Current Time: Thu Mar 28 04:20:09 CDT 2024