Populate table with resultset from a Stored program call

From: Gary M Cabana <gcabana_at_gis.net>
Date: 19 Nov 2002 04:26:28 -0800
Message-ID: <5c5ced77.0211190426.604796bb_at_posting.google.com>

SQL Server has the statement

INSERT INTO tablename
EXEC spName

Can this be done in Oracle without using dynamic sql?

thanks in advance!! Received on Tue Nov 19 2002 - 13:26:28 CET

This message: [ Message body ]
Next message: Jim Kennedy: "Re: Populate table with resultset from a Stored program call"
Previous message: Elizabeth Kim: "how to delete windows2000 oracle services"
Next in thread: Jim Kennedy: "Re: Populate table with resultset from a Stored program call"
Reply: Jim Kennedy: "Re: Populate table with resultset from a Stored program call"
Reply: Jusung Yang: "Re: Populate table with resultset from a Stored program call"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message