Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!87.79.20.105.MISMATCH!news.netcologne.de!ramfeed1.netcologne.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!r6g2000vbf.googlegroups.com!not-for-mail From: jodleren Newsgroups: comp.databases.oracle.misc Subject: data to procedure? packed data? Date: Thu, 11 Nov 2010 01:35:03 -0800 (PST) Organization: http://groups.google.com Lines: 26 Message-ID: NNTP-Posting-Host: 194.126.122.72 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1289468104 15071 127.0.0.1 (11 Nov 2010 09:35:04 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 11 Nov 2010 09:35:04 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: r6g2000vbf.googlegroups.com; posting-host=194.126.122.72; posting-account=OiJc3goAAACVckaxOSC-aEp1AzEnXor2 User-Agent: G2/1.0 X-HTTP-Via: 1.0 jot02s14.joteesti.ee:3128 (squid/2.6.STABLE9) X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20100106 Firefox/3.5.7,gzip(gfe) Xref: news.cambrium.nl Hi all I need to send data to this thing - and I guess that the "selite" (explanation) is an array or something. Just how do I do that? I understand all the parameters, except the first one - and "comment" is possible, but the product ID / name an option, as the procedure should need to know what to work with. Any ideas? Sonnich procedure VarastopaikkaSiirrot(ppSelite Vararasto_pack.vctable, Function VarastoPaikkaSiirrot2(ppJuoksu in pls_integer, ppPaikat in Vararasto_pack.intTable, ppPaikka in pls_integer, ppMuutos Vararasto_pack.floatTable, ppMuutos in number, ppTyyppi in char default 'S' ppTyyppi in char, ) is ppSelite in varchar2) return pls_integer is